Plz Help

[anupamasuresh]

Hi all,

I have a table with composite primary key. The query I have has where clause which includes some columns of composite key . But still the query is very low. Is there any other means to improve the performance of the query

Plzz do help me out

Thanks
Anu

Sorry the table structure is
table1
KEY1 NUMBER NOT NULL,
Key2 NUMBER NOT NULL,
Key3 NUMBER NOT NULL,
Ke4 NUMBER NOT NULL,
Key5 NUMBER NOT NULL,
Key6 NUMBER NOT NULL,
Key8 NUMBER NOT NULL,
Key9 NUMBER NOT NULL,
Key10 DATE NOT NULL,
Key11 NUMBER NOT NULL,
PROD NUMBER NOT NULL,
CON NUMBER
OT NUMBER

Query is: SELECT DISTINCT (Key1),Key2
FROM Table1