Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> LMT problems ...
Hi Jonathan,
it makes no difference I'm afraid, ALAYZE or DBMS_STATS both have no effect on the outcome.
Cheers,
Norman.
Clones are people two.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]
Posted At: Saturday, July 27, 2002 8:24 PM
Posted To: server
Conversation: LMT problems ...
Subject: Re: LMT problems ...
It might be worth checking if the problem reproduces if you switch from using ANALYZE to using dbms_stats() (or vice versa if you are doing your analyse with dbms_stats). Received on Mon Jul 29 2002 - 03:06:26 CDT