P
Paul Koufalis
Guest
HPUX OE 10.2B03 After running update statistics on a DB, disk I/O went through the roof and performance tanked. Some VERY simple queries were taking forever even though the correct index was being used. I had to delete the statistics and then everything went back to OK. Example query (using sports.customer table) Index: order.custnum + Order.OrderDate (BOTH CHAR fields) Query: SELECT * FROM order WHERE custnum = 123 AND OrderDate '20141206' AND OrderDate '20141231' In the 4GL this returns maybe 100 rows. In SQL it ran and ran and ran.... I did not keep detailed notes during the actual PROD incident but I seem to remember that doing the SELECT with just one OrderDate condition was fine. Dev is running 10.2B08 and while I can't say I explicitely tested this query, there were no issues reported. I will be going back to the DEV box and testing 10.2B03 and 10.2B08 with and w/out statistics but in the meanwhile I would love to hear from you guys.
Continue reading...
Continue reading...