| Urgent!! [message #58953] |
Fri, 17 October 2003 09:59  |
Kapil
Messages: 145
Registered: May 2002
|
Senior Member |
|
|
|
What can be done if all the application developers reports are running slow in prod and running good on dev. this schema has 100 tables, and 200 indexes. just need to know where to start, and what thinks should i look in. please help needed.
|
|
|
|
| Re: Urgent!! [message #58960 is a reply to message #58953] |
Fri, 17 October 2003 22:14  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
make sure you gather statistics on the tables (assuming you are using cost based optimizer).
look at the sql they are running, and the find the access path (explain plan). see if the indexes are being used.
if possible make dev environment look like production (volume of data) and see if they still run good in development.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
