re: local non-prefixed partitioning strategy; 9.2.0.6

hey guys, I have a quandary.
  Most my datawarehouse tables are partitioned nicely by range by a date.   I also have nice local prefixed indexes. Cool !    

  Now, I am thinking of implementing local non-prefixed indexes that nowhere have the partitioned key in them .... so no relationship whatsoever to the part key.    

  Question, for partition maintenance, statistics gathering, querying, is Oracle smart enough to:

• gather index stats only on the records belonging to the appropriate partition (of the non-prefixed index) ? -- it would seem so.

  --for querying, most likely it will need to do full index scans across all partitions (depends, but most likely) so probably this will only be beneficial for partition maintenance (so that the entire index will not need to be rebuilt).    

  this is my understanding...am I missing something?   thx,
  Cos

--
http://www.freelists.org/webpage/oracle-l