Re: Index performance
Rick,
Thank you for your reply. For some reason my reply went into the la-la land for moderation and never came back...
I tried your modified query - and the numbers are the same (ugly)...
I checked the slow query log, and the number of rows examined is what one would expect - the number of records in the <ID list table> x approx. 7... So, for 3500 rows in the ID table, we get about 23000 records examined.
It shows 0 for lock time, and there is nothing else unusual... I even went on to replace a join on the infamous GUID to using integer IDs instead... After all, 4 bytes is better - fits more into index pages.
As for the disk subsystem, this machine has 6 x 500GB 7.2K RPM SATA 3.5" disks hooked up to a PERC 6/I with 256MB Cache. We are using RAID-10.
Any other ideas?
Thanks!!!
--Alex
Subject
Views
Written By
Posted
4389
June 15, 2010 08:30AM
1252
June 16, 2010 09:54AM
1363
June 16, 2010 12:03PM
1498
June 16, 2010 08:47PM
Re: Index performance
1399
June 20, 2010 02:30PM
1233
June 20, 2010 11:05PM
1539
June 21, 2010 07:35AM
1195
June 21, 2010 09:21AM
1212
June 21, 2010 10:31AM
1330
June 21, 2010 06:43PM
1514
June 21, 2010 06:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.