Re: why not a full table scan

Oracle 9204.

Yes thats a table created using insert statement more than a few times. I did update the last_ddl_time though.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:csai0u$i8h$1_at_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 Wed Jan 19 2005 - 19:04:02 CST