Re: Odd, Rulebased query improves with statistics!!?

From: Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net>
Date: 2000/03/25
Message-ID: <il1D4.19543$mf.1512014@bgtnsc05-news.ops.worldnet.att.net>#1/1

Are you sure the hint is recognized? I would run explain plan under both scenarios and compare results.

Yurasis Dragon <yurasis_dragonNOSPAM_at_yahoo.com> wrote in message news:38dd5fcd.31409915_at_news.rdc1.ab.home.com...
> Has anyone had the experience of having a query with a RULE hint
> improve as the result of tables being analyzed? We have had a query
> improve from 1 min. 36 secs. run time to 6 seconds by analyzing the
> tables in the query. I don't get it.
>
> Anyone similar else with similar experiences? By the way, we're using
> 7.3.4 in Solaris 2.5 and 8.0.5 and Digital Unix (can't remember the
> version).
>
> Thanks in advance for any comments.
>
>
>
> ===
>
> Yurasis Dragon
> yurasis_dragonNOSPAM_at_yahoo.com
> (remove NOSPAM to reply)
Received on Sat Mar 25 2000 - 00:00:00 CST