which are the parameter to be set so get better performance for more SELECT statements.
clients are accessing thro web. There more select statements than inserts or updates. Some of the queries used to take 10-20 secs to execute. After loading a new module it is taking more time 110-120 secs to retrieve the data for a select statement.
O.S sun 2.7
Application : WEB application
[Edited by shashikumar on 02-20-2002 at 05:51 AM]
what do u mean more select statements.Please be more clear
Have you analyze your Stats?
More info required
The brain is a wonderful organ; it starts working the moment you get up in the morning and does not stop until you get into the office.
Trace long running statements and query explain plan using TKPROF.
Use TKPROF results to determine whether full table scans/inefficient SQL/Indexes.
Read this link.
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
I've followed the link that Sureshy pointed out, But I'm more confused after reading it. How do you interpret explain plan? Do you read it from inside out, top to bottom, or bottom to top? I don't see the pattern from the examples given on this document. Could some one be kind enough to explain "how do you read an explain plan"? Thanks so much.
You read the explain plan from inside out then top bottom.
Click Here to Expand Forum to Full Width