Payday loan very quickly they often decide Emergency Payday Loans Emergency Payday Loans not refusing to new one.

Home > oracle > Outline不能正确使用的问题

Outline不能正确使用的问题

October 13th, 2008

今天同事遇到一个outline不能正确使用的问题问我。抽象描述类似于下面的问题

create outline ol3732308613_tmp for category GOOD_PLAN on
select /*+ index(a,a_idx) */ … from a;

生成outline后,explain plan select /*+ index(a,a_idx) */ … from a; 却发现没有走a_idx,而是选择了full table scan

我看了一下ol$hints表,发现其并没有使用index hint,而是使用了INDEX_RS_ASC,并且还有一个hint为OPTIMIZER_FEATURES_ENABLE(’9.2.0′)

数据库版本为10g,optimizer_features_enable为9.2.0。这样的话INDEX_RS_ASC这个hint不能被识别,因为其为10g所引入的。

在创建outline前加上alter session set optimizer_features_enable=’10.2.0.3′ 就可以了

这样OPTIMIZER_FEATURES_ENABLE(’9.2.0′) 被替换为OPTIMIZER_FEATURES_ENABLE(’10.2.0.3′)。INDEX_RS_ASC 可以被正确使用。

about INDEX_RS_ASC (from jonathanlewis’s blog)

Bonus: The index() hint tell Oracle to use an index, but does not specify whether that the usage should be a full scan or a range scan. Because of some changes in costing in 10g, there have been cases reported where the optimizer – after hinting – picked a full scan when a range scan would have been a more intelligent choice. Consequently Oracle Corp. has introduced three new hints in 10.2.0.3 to “disambiguate” the index use. These are: index_rs(), index_rs_asc(), index_rs_desc(), which make explicit demands for an index range scan. It’s probably a good idea to use this option in all future code.

Eagle Fan oracle

  1. August 3rd, 2013 at 01:35 | #1

    Very well written article. It will be valuable to everyone who employess it, as well as me. Keep doing what you are doing – can’r wait to read more posts.

  2. August 5th, 2013 at 03:22 | #2

    It is perfect time to make some plans for the future and it’s time to be happy. I have read this post and if I could I want to suggest you some interesting things or tips. Perhaps you can write next articles referring to this article. I want to read even more things about it!

  3. August 5th, 2013 at 07:57 | #3

    I am just commenting to let you understand of the cool experience my friend’s daughter encountered browsing the blog. She came to find too many details, including what it’s like to possess an incredible giving spirit to let the mediocre ones without hassle learn about a number of tricky things. You truly exceeded readers’ expectations. Thanks for coming up with the powerful, trustworthy, revealing and unique tips about the topic to Jane.

  4. August 6th, 2013 at 08:01 | #4

    Wonderful goods from you, man. I have understand your stuff previous to and you’re just too fantastic. I actually like what you have acquired here, really like what you’re stating and the way in which you say it. You make it entertaining and you still take care of to keep it smart. I can’t wait to read much more from you. This is really a tremendous web site.

  5. August 6th, 2013 at 09:58 | #5

    hello there and thank you for your information – I’ve definitely picked up anything new from right here. I did however expertise some technical points using this website, as I experienced to reload the web site many times previous to I could get it to load properly. I had been wondering if your web hosting is OK? Not that I’m complaining, but slow loading instances times will sometimes affect your placement in google and could damage your high quality score if ads and marketing with Adwords. Anyway I am adding this RSS to my e-mail and can look out for a lot more of your respective fascinating content. Ensure that you update this again very soon..

  6. August 7th, 2013 at 14:50 | #6

    Reminds me in the “street lit” debate.

  7. August 9th, 2013 at 21:58 | #7

    I believe other website proprietors should take this internet site as an example, very clean and excellent user pleasant pattern.

  8. August 12th, 2013 at 18:47 | #8

    Having read this I thought it was extremely informative. I appreciate you spending some time and energy to put this article together. I once again find myself personally spending a lot of time both reading and posting comments. But so what, it was still worthwhile!

  9. August 17th, 2013 at 06:02 | #9

    There are definitely a variety of particulars like that to take into consideration. That may be a nice level to carry up. I supply the ideas above as normal inspiration however clearly there are questions just like the one you carry up the place a very powerful factor shall be working in trustworthy good faith. I don?t know if greatest practices have emerged round issues like that, however I’m positive that your job is clearly recognized as a good game. Each girls and boys really feel the affect of only a second�s pleasure, for the remainder of their lives.

  10. August 17th, 2013 at 15:05 | #10

    I�m impressed, I must say. Really rarely do I encounter a blog that�s both educative and entertaining, and let me tell you, you’ve got hit the nail on the head. Your idea is outstanding; the issue is something that not enough people are speaking intelligently about. I am very happy that I stumbled across this in my search for something relating to this.

  11. August 23rd, 2013 at 15:05 | #11

    Nice post. I learn something more challenging on different blogs everyday. It’ll always be stimulating to read content from other writers and practice slightly something from their store. I�d choose to use some with the content on my blog whether you don�t mind. Natually I�ll give you a link on your web blog. Thanks for sharing.

  12. August 23rd, 2013 at 15:47 | #12

    Youre so cool! I dont suppose Ive read anything like this before. So nice to search out any individual with some authentic thoughts on this subject. realy thank you for starting this up. this website is something that is needed on the net, someone with somewhat originality. useful job for bringing something new to the internet!

  13. August 24th, 2013 at 12:12 | #13

    Thank you, I have been hunting for information about this subject for ages and yours would be the finest I’ve located so far.

  14. August 30th, 2013 at 19:47 | #14

    Thanks for sharing these kind of wonderful posts. In addition, an excellent travel and medical insurance strategy can often eradicate those considerations that come with visiting abroad. Some sort of medical emergency can soon become very expensive and that’s absolute to quickly set a financial weight on the family finances. Having in place the ideal travel insurance deal prior to leaving is well worth the time and effort. Thanks a lot

  15. August 31st, 2013 at 08:30 | #15

    I’ve been exploring for a little for any high quality articles or weblog posts in this sort of space . Exploring in Yahoo I eventually stumbled upon this website. Reading this information So i’m satisfied to exhibit that I have a very excellent uncanny feeling I came upon exactly what I needed. I such a lot unquestionably will make sure to don’t forget this website and give it a look regularly.

  16. September 1st, 2013 at 00:22 | #16

    Definitely, what a magnificent blog and revealing posts, I surely will bookmark your website.Best Regards!

  17. September 5th, 2013 at 08:00 | #17

    An amazing reveal, I just certain this on some colleague who had been doing fairly psychiatry for this. And he in certainty bought me breakfast as I establish it pertaining to him.. smile. So i neediness to modify that: Thnx for the treat! But sure Thnkx with regard to spending calculate to natter about this, I experience strongly regarding it and enjoy appraisal additional taking place this topic. If reasonable, as you deem expertise, would anyone mind updating your blog with more details? It can be present exceedingly height used for me. Big browse up emphatically in support of this blog post!

  18. September 19th, 2013 at 14:34 | #18

    I would like to thank you for the efforts you’ve put in writing this web site. I am hoping the same high-grade website post from you in the upcoming also. Actually your creative writing abilities has inspired me to get my own website now. Actually the blogging is spreading its wings rapidly. Your write up is a great example of it.

  19. October 18th, 2013 at 15:25 | #19

    Hello! Accomplish you identify qualification they compose some plugins to evade with Explore Engine Optimization? I’m difficult to get my blog to rank on behalf of some under fire keywords but I’m not considering very sunny gains. Condition you get of some entertain distribute. Welcome it!

  20. October 18th, 2013 at 19:38 | #20

    I was fantastically thrilled to find this situate resting on google.I sought after to say merit to you with regard to this admirable article!! I certainlyliked all insufficiently crumb of it and I’ve you bookmarked to look hooked on new stuff you post.

  21. October 18th, 2013 at 21:39 | #21

    Glorious blog! Accomplish you’ve any dreams and hints for aspiring writers? I’m planning to arise my own site in a little while except I am vaguely misplaced proceeding the lot. Would you plan first with a emancipated platform comparable WordPress before go representing a compensated possibility? Near are such a lot of choices outdated in attendance that I’m completely overwhelmed .. Any suggestions? Admire it!

  22. October 18th, 2013 at 22:36 | #22

    Its comparable you recite my mind! You appear to know a lot on the subject of this, approximating you wrote the book in it otherwise impressive. I ponder that you could do with approximately pics to drive the message home-grown a little bit, except supplementary than that, this is abundant blog. A abundant glance at. I will certainly ensue back.

  23. November 27th, 2013 at 16:43 | #23

    I delight in, cause I found just what I used to be taking a look for. You’ve ended my 4 day long hunt! God Bless you man. Have a great day. Bye

  24. December 8th, 2013 at 10:41 | #24

    Hello, you used to write magnificent, but the last few posts have been kinda boring… I miss your great writings. Past several posts are just a bit out of track! come on!

  25. January 28th, 2014 at 16:16 | #25

    Casana I was recommended this website by my cousin. I am not sure whether this post is written by him as nobody else know such detailed about my difficulty. You are wonderful! Thanks! your article about image1

  26. January 28th, 2014 at 20:55 | #26

    http://www.traxxcorp.com/Brands/?keywords=Coach+Handbags+Discount I can also tеl you from սgilizinǥ the school i alwаys have been at Kindergarten Screenijɡ and witnesѕed and experienced childreո crying.Gruyeгe is the ϲheese traditionally utilised in gougeres, but itts subtle nuttiness is
    wasted in pte choux, whose butteriness and eegginess smother just about the mօst robսst
    flavors. Ebay Coаch Hanԁbags

  27. February 19th, 2014 at 09:22 | #27

    I am only commenting to make you understand what a terrific experience my friend’s child had reading through your web page. She picked up a lot of pieces, including what it’s like to have an amazing helping mindset to make most people without difficulty master a variety of complicated topics. You actually did more than our expectations. Thank you for producing the powerful, healthy, informative and in addition cool guidance on this topic to Lizeth.

  28. February 19th, 2014 at 13:47 | #28

    One important issue is that if you are searching for a education loan you may find that you will want a cosigner. There are many cases where this is correct because you may find that you do not possess a past credit score so the loan provider will require you have someone cosign the financing for you. Great post.

  29. March 4th, 2014 at 19:33 | #29

    With every thing which appears to be building within this subject matter, your viewpoints happen to be rather exciting. Having said that, I beg your pardon, because I can not subscribe to your entire theory, all be it exciting none the less. It looks to everybody that your opinions are actually not completely rationalized and in reality you are generally yourself not entirely certain of the argument. In any case I did enjoy reading it.

Comment pages
  1. No trackbacks yet.