Oracle Scratchpad

January 27, 2014

Expert

Filed under: Oracle — Jonathan Lewis @ 9:18 am BST Jan 27,2014

A recent “Hot topics” email from Oracle support listed the following bug as one which had recently been updated:


17727676 OPTIMIZER HINT IGNORED  WHEN USING INVISIBLE INDEXES

Since the optimizer is one of my pet topics I thought I’d take a quick look at what it said – and found this heart-warming introduction;


Hdr: 17727676 11.2.0.3.0 RDBMS 11.2.0.3.0 QRY OPTIMIZER PRODID-5 PORTID-226
Abstract: OPTIMIZER HINT IGNORED WHEN USING INVISIBLE INDEXES
*** 11/03/13 03:46 am ***

PROBLEM:
--------
Based on a blog article from the international recognized Oracle Expert Jonathan Lewis ...

If it’s on MoS surely it’s just got to be true!  (Yes, I know I’ve said the opposite in the past – but it’s definitely right some of the time)

The bug/blog in question was this one, and the problem is fixed in 12.2

3 Comments »

  1. Hello Jonathan,

    we had some issues with invisible indexes and MOS told us, that they don’t know anything about it.
    After we have send them a link to your “Invisible ?” arcticle, they did some research and now we will get a patch for that problem.
    That’s how it started…the rest is history ;-)

    Best regards,
    Matthias Schulz

    Comment by Matthias Schulz — January 27, 2014 @ 12:01 pm BST Jan 27,2014 | Reply

  2. Mattthias,

    So you’re the one I have to thank for: “international recognized Oracle Expert”
    It’s nice to know that my posts are useful occasionally.

    Comment by Jonathan Lewis — January 27, 2014 @ 1:39 pm BST Jan 27,2014 | Reply

    • Hello Jonathan,

      I don’t know who wrote “international recognized Oracle Expert”, but I feel guilty of mentioning your article.
      Your quote “my posts are useful occasionally” might get you a nomination for the understatement of the year – of course they are!

      Comment by Matthias Schulz — January 27, 2014 @ 4:39 pm BST Jan 27,2014 | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 3,508 other followers