Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question regarding SAMPLE clause.
I believe so - but this may vary with
version of Oracle.
If you run dbms_stats() with sql_trace on,
there are definitely some cases where
you see a messy SQL statement being
executed recursively by the package -
and this SQL usually has a SAMPLE()
or SAMPLE BLOCKS () clause in it.
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) ____UK_______March 19th ____UK_______April 8th ____UK_______April 22nd ____USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html "Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:YMk9a.442$pK2.566_at_news.indigo.ie...Received on Wed Mar 05 2003 - 06:02:22 CST
> A speculation :
>
> The sample clause is using the same functionality as DBMS_STATS for
> ESTIMATE ?