OracleProgrammerwith
Programmer
I had a table with 32 columns out of which one is a composite primary key and have 10 foriegn keys.
I am writing a simple query with where clause having a composite primary key.
But still I am getting cost of the query as 37.
Can you please suggest how can i optimize the cost of the query.
select col4
from table
where col1 = x
and col2 = y
and col3 = z
Col1,Col2 and Col3 are the composite primary key.
Thanks in Advance.
Dhiren Shah
I am writing a simple query with where clause having a composite primary key.
But still I am getting cost of the query as 37.
Can you please suggest how can i optimize the cost of the query.
select col4
from table
where col1 = x
and col2 = y
and col3 = z
Col1,Col2 and Col3 are the composite primary key.
Thanks in Advance.
Dhiren Shah