Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question regarding SAMPLE clause.

Re: Question regarding SAMPLE clause.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 5 Mar 2003 12:02:22 -0000
Message-ID: <b44pr6$65$1$8300dec7@news.demon.co.uk>

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...

> A speculation :
>
> The sample clause is using the same functionality as DBMS_STATS for
> ESTIMATE ?
Received on Wed Mar 05 2003 - 06:02:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US