Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: analyzing tables
Paul Osborn wrote:
>
>
> Waqar Hasan wrote:
>
>> I am developing a large DSS application and want to minimize the
>> time spent in analyzing tables. I have some questions on the
>> value/cost of
>> analyzing tables.
>>
>>
>
<snip>
>> (a) which statistics are the most useful to collect and which ones
>> are the
>> most time consuming to collect.
>
> is the hard part. Putting the data in a histogram, spider chart, 3-D
> graph, etc. seems secondary - unless I'm missing something.
>
You are missing something. In fact you have completely missed the point. The question was about collecting table statistics using the analyse table command, not the general monitoring of database perofmrance statistics.
>
Received on Tue Dec 23 1997 - 00:00:00 CST