Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problems with explain plan in 9i EE for linux
analyze table emp compute statistics;
Regards
HJR
-- ---------------------------------------------- Resources for Oracle: http://www.hjrdba.com =============================== "Sławomir Marcinkowski" <s.marcinkowski_at_Bankier.pl> wrote in message news:a4ftdd$2e6$1_at_news.tpi.pl...Received on Thu Feb 14 2002 - 02:54:31 CST
> if I call query like this one:
> EXPLAIN PLAN
> INTO plan_table
> FOR
> select * from emp;
>
> and run script: @utlxpls.sql, I always get:
>
> Plan Table
> --------------------------------------------------------------------------
--
> --------------
> | Operation | Name | Rows | Bytes| Cost |
> Pstart| Pstop |
> --------------------------------------------------------------------------
--
> --------------
> | SELECT STATEMENT | | | | |
> | |
> | TABLE ACCESS FULL |EMP | | | |
> | |
> --------------------------------------------------------------------------
--
> --------------
>
>
> I mean, that where is no rows, bytes, cost, etc. What should I do, to
> correct it?
>
> Slawek,
> Poland
>
>