response time [message #37616] |
Sun, 17 February 2002 18:30 |
krishna
Messages: 141 Registered: October 1998
|
Senior Member |
|
|
I have indexed my deptno column (index name is ind1) in my emp table which contains about a million rows. (I have only one index in my emp table) Suppose i give a query like
select /*+no_index(emp ind1)*/ ename from emp where deptno=40
and i note the time taken to service the request.
Now i want to see how forcing the optimizer to use ind1 will improve the response time
So i give the query
select /*+index(emp ind1)*/ ename from emp where deptno=40 immediately after i gave the previous query
Now obviously there should be an improvement in the response time. But what i want to know is that, is this improvement
due to using the index or is it due to the fact that i issued this command(which basically gives the same result as the previous query) immediately after the query without any index, the result of which would have been in cache?
|
|
|
|