Re: ANALYZE COMMAND

From: Jeremy Russell <jeremyr_at_spam-spam-spam-spam-loverly-spam-dircon.co.uk>
Date: Mon, 25 May 1998 10:57:53 GMT
Message-ID: <35694e43.31677127@news.dircon.co.uk>

Sure you can. It's the stats gathered by the "analyze" command that invoke the cost based optimizer though. Put the hint /*+ RULE */ on SQL statements that you want to use with the rule-based version to override the stats.

Why do you want to do that anyway?

qutub_at_hotmail.com wrote:

>Hi ,
>
>
>Can i use Analyze command if the rule based Optimizer. is in use.
>
>
>Thanks
>Abdulla
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Mon May 25 1998 - 05:57:53 CDT