Home » SQL & PL/SQL » SQL & PL/SQL » performance
performance [message #37676] Wed, 20 February 2002 02:36 Go to next message
Messages: 141
Registered: October 1998
Senior Member
I created a table called large_table. I inserted around 10,000 rows into it. It contains three columns
sl_no(primary key), name, and address.
After inserting values into the table i indexed the name column.
Now i issue a query with a hint forcing the optimizer to ignore the hint. Now i issue a query with a hint forcing the optimizer to use that hint. How can i be sure that the improvement in the second query's performance is due to the hint only and not due to the results of the first query being in cache? Short of shutting down the database and starting it up again, is there any other way? And by the way, does shutting down and starting up ensure that the results of the first query do not remain in cache?
Re: performance [message #37677 is a reply to message #37676] Wed, 20 February 2002 03:30 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
before executing the 2nd command flush the shared pool.

alter system flush shared_pool;
Previous Topic: striping
Next Topic: foregin composite key
Goto Forum:

Current Time: Fri Sep 24 08:04:56 CDT 2021