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......
Expand|Select|Wrap|Line Numbers
- SELECT entrykey,uniquekey FROM frt_app.ENTRIES_WES WHERE uniquekey=9422077251
- --This is fast [i have createdit as primary key]
- SELECT entrykey,uniquekey FROM frt_app.ENTRIES_WES WHERE entrykey=983654
i also tried by creating index..........but i am not able to solve
Please kindly help me .....This is very urgent.......