bizarre SQL Advisor recommendation result

  • From: Patrice sur GMail <patrice.boivin@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 15 Mar 2016 11:37:07 -0300

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>

Other related posts: