select query is taking some time to return values

[Kumarswamy]

Hi,
I have a problem, i have used one condition in where clause .....
but it is taking some time to return values.......
so my procedure is taking lot of time.......
for the same table if i query with another column in where clause within fraction of second i getting values.......

This query is taking some time......
[code=oracle]

SELECT entrykey,unique key FROM frt_app.ENTRIES _WES WHERE uniquekey=94220 77251

--This is fast [i have createdit as primary key]

SELECT entrykey,unique key FROM frt_app.ENTRIES _WES WHERE entrykey=983654

[/code]



i also tried by creating index.......... but i am not able to solve
Please kindly help me .....This is very urgent.......

[amitpatel66]

Hi,
I have a problem, i have used one condition in where clause .....
but it is taking some time to return values.......
so my procedure is taking lot of time.......
for the same table if i query with another column in where clause within fraction of second i getting values.......

This query is taking some time......
[code=oracle]

SELECT entrykey,unique key FROM frt_app.ENTRIES _WES WHERE uniquekey=94220 77251

--This is fast [i have createdit as primary key]

SELECT entrykey,unique key FROM frt_app.ENTRIES _WES WHERE entrykey=983654

[/code]



i also tried by creating index.......... but i am not able to solve
Please kindly help me .....This is very urgent.......

Yes, the way to get the correct data from the table is using a primary key column in WHERE clause. So why dont you use Primary key column it self?

[Saii]

Can you run an explain plan on the query. Also can mention details about the size of table, column specs and what index you created and whether that was referenced during execution.