Re: /*+ opt_param('OPTIMIZER_USE_INVISIBLE_INDEXES' 'TRUE') */

  • From: Stefan Koehler <contact@xxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx, djeday84@xxxxxxxxx
  • Date: Thu, 25 May 2017 09:57:56 +0200 (CEST)

Hey Anton,
here we go: http://www.soocs.de/public/scripts/e2sn_hint_hierarchy.sql

As i already said it is basically the script of Tanel Poder
(http://blog.tanelpoder.com/2013/04/01/understanding-what-a-hint-affects-using-the-vsql_feature-views/)
 but includes the version in which the hint was
introduced.

The version information is not 100% accurate but AFAIK there is no other way to 
figure out when a hint (and the corresponding transformation) was
introduced.
 
Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @OracleSK
Upcoming online seminar: http://tinyurl.com/17-06-13-Shared-Pool-Internals

Anton <djeday84@xxxxxxxxx> hat am 25. Mai 2017 um 09:30 geschrieben:


Stefan, could you please share your script
--
//www.freelists.org/webpage/oracle-l


Other related posts: