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
