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 -> Q: Analyze table for all indexed columns

Q: Analyze table for all indexed columns

From: EnderW <ender29_at_my-deja.com>
Date: Wed, 18 Oct 2000 19:05:48 GMT
Message-ID: <8sksa5$aps$1@nnrp1.deja.com>

Hi,
  I have a dilemma, I am using analyze table xxx compute statistics for all indexed columns to do my regular analyze. However, it doesnot print a time stamp on user_tables "last_analyzed" column, it is simply null. Does that mean this command does not work and doesnot analyze ? If it does analyze, why is there no timestamp there ? What am I missing simply ? Thanks

--
Ender Wiggin


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Oct 18 2000 - 14:05:48 CDT

Original text of this message

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