bizarre SQL Advisor recommendation result
From: Patrice sur GMail <patrice.boivin_at_gmail.com>
Date: Tue, 15 Mar 2016 11:37:07 -0300
Message-ID: <CACH2EDJLrG-nkdkeUQRX51D1JrGrJ7wkvK1iOULZ55jSwSKGnw_at_mail.gmail.com>
Original Cost:
4
Date: Tue, 15 Mar 2016 11:37:07 -0300
Message-ID: <CACH2EDJLrG-nkdkeUQRX51D1JrGrJ7wkvK1iOULZ55jSwSKGnw_at_mail.gmail.com>
Original Cost:
4
New Cost:
344
Cost Improvement:
-340
Cost improvement (%):
-8,500.00
YMMV
It recommends partitioning a table, but then tells me I can then expect
-8500% performance gain.
yay
- Patrice My profiles: [image: Facebook] <http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image: LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image: Twitter] <http://www.twitter.com/PatriceBoivin>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 15 2016 - 15:37:07 CET