Re: SQL Profiles in 10g

• Post for FREE via your newsreader at post.usenet.com ****

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:ch95dt$d2h$1_at_hercules.btinternet.com...

> Possibly you've found a plan where


>     checking more options doesn't help

>     changing the stats doesn't change the choice of plan

>     new, hypothetical, transformations don't help.


Hi Jonathan

After tracing SQLTUNE and analyzing the output, my guess is: - the problem with cardinality estimation was recognized - since no better plan has been found, no SQL profile has been stored

Posting more information about my findings makes not sense, too much data... I send them to you per email, if you are interested give them a look, otherwise just press delete!

Thanks a lot for your help.

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=