how to use Primary index efficiently

Hi,

Here i have a situation that

In my table PI is defined on combination of 3 columns Col A, Col B, Col C, but in my query we are using where condition on only one column Col A, Here the optimizer is not taking the advantage of PI, bz the PI is not matching, and my query is taking more time to execute, plz give me some tuning tips..

one more question, if i want to use combination of 3 columns (Col A,Col B, Col C) in my where condition what is the syntax

Re: how to use Primary index efficiently

Satish,

Your query will not the advantage of UPI because the hash will be different for col1 and the combination of col1,col2 and col3.So if you want to take that advantage you have to use col2 and col3 in where clause.

Or you can try and check below suggestions :

1) Define PPI on col1 if that contained any range based data 2) collect stats on col1

Also if can poast some sample data of col1, col2 and col3 then further can be suggest.Also post the row count and time taken by queries.