| parth |
Posted: Apr 03, 2007 09:50:07 AM |
Total Post: 17
Joined: Apr, 2007
|
| hi, i have an issue with Indexes cause my client is generating report (For all the employees and data is of Payroll ) so it is taking very much time and i have tried out monitoring index and it is working correctly, but it is still taking time, i have also tried driving table and driven table funda everything is in Order but i am not able to figure out that why it is taking so much of time ...? can any one help me |
|
|
 Jayanta |
| Posted: Apr 03, 2007 01:28:31 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
u may try rebuilding the index!
cheers!
|
|
|
|
|
| bigPapas |
| Posted: Apr 03, 2007 05:49:44 PM | |
|
Total Post: 14
Joined: Apr, 2007
|
have you looked at your statistics? Make sure they are current on index and table. If so, generate explain plan and verify that the query is doing what it should.
best regards
|
|
|
|
|
| snehalatha |
| Posted: Apr 04, 2007 12:32:24 AM | |
|
Total Post: 169
Joined: Apr, 2006
|
Hi,
1. Check the index is Composite or not.
2. Check the joins
3. check the table order you have given in FROM statement.
4. take the explain plan and see the statistics. check any full table scan going .
|
|
|
|
|
| Sabdar Syed |
| Posted: Apr 04, 2007 03:36:50 AM | |
|
Total Post: 39
Joined: Mar, 2007
|
When was the last time that the tables were analyzed?. If you find very long back, and many insertions occur during these periods, I request you to gather statistics on those tables.
Regards,
Sabdar Syed.
http://sabdarsyed.blogspot.com/
|
|
|
|
|
| bigPapas |
| Posted: Apr 04, 2007 09:15:34 AM | |
|
Total Post: 14
Joined: Apr, 2007
|
Don't be fooled by full table scans. Sometimes a full table scan is faster, depending on the number of rows in querried table. If a small table is getting a full table scan, it is quite possible that it is faster to do the full, than look at index.
Once again, I would look at statistics. If there have been large inserts, or deletes, stats need to be run again.
Best regards,
Gabe
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
