Re: why not a full table scan

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 15 Jan 2005 07:50:54 +0000 (UTC)
Message-ID: <csai0u$i8h$1@sparta.btinternet.com>

Which version of Oracle - precisely.

Given the call to dbms_stats, it matters a lot.

And can we did you creates the test data by doing the following a few times:

insert
select

rownum rnumb, o.*
from all objects
;

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated Dec 23rd 2004






"Oradba Linux" <techiey2k3_at_comcast.net> wrote in message 
news:EJGdnXDBXuxmrH7cRVn-gA_at_comcast.com...


> SQL> desc test_plsql.test_dbms

> Name                                      Null?    Type

> ----------------------------------------- -------- ------------------------

> ----

> RNUM                                               NUMBER

> OWNER                                              VARCHAR2(30)

> OBJECT_NAME                                        VARCHAR2(128)

> SUBOBJECT_NAME                                     VARCHAR2(30)

> OBJECT_ID                                          NUMBER

> DATA_OBJECT_ID                                     NUMBER

> OBJECT_TYPE                                        VARCHAR2(18)

> CREATED                                            DATE

> LAST_DDL_TIME                                      DATE

> TIMESTAMP                                          VARCHAR2(19)

> STATUS                                             VARCHAR2(7)

> TEMPORARY                                          VARCHAR2(1)

> GENERATED                                          VARCHAR2(1)

> SECONDARY                                          VARCHAR2(1)

>

>

> SQL> select count(*) from test_plsql.test_dbms;

7>


>  COUNT(*)

> ----------

>   1176251

Received on Sat Jan 15 2005 - 01:50:54 CST