adding the partition column to the right side of every local non-prefixed index to improve performance?

Hello all,

I have heard oracle have some performance issues on local non-prefixed index.
And one expert told me to add the partition column to the right side of every non-prefixed local index to improve performance. I mean if the table has three columns: A,B,C, and the partitioned on the column A.
and a local index on the column B, should be converted to a composite index on column B,A.

I'm not quite sure about this method. Here I'd like someone to share his expeerience on the local non-prefixed index.

And my oracle version is 8.1.7.2.0，Does this version has partition bugs?

Thanks a lot.

-Xiang Zhao Received on Mon Jan 13 2003 - 09:45:50 CST