Re: Query takes 1min 15 secs and tables are indexed !

On 31 Jul 2006 10:39:32 -0700, "Big Charles" <cherediatech_at_yahoo.com> wrote:

>Thanks !
>
>I did:
>
>exec dbms_stats.gather_database_stats(CASCADE=>TRUE);
>
>and the query speed improve a lot! Now it takes no more than 3 seconds.
>
>I'm wondering:
>
>- Should I run Statistics from time to time, like every 3 days, or once
>a week... why?
>- About table PADRON which has 16.5 millions records: I also think that
>there is something wrong with the table, because a Record Count with
>Oracle 10g Release 10.1.0.4.0 can not take 1 minute.
>
>Brian, I tried to do:
>ANALYZE TABLE pardon LIST CHAINED ROWS;
>but my user has not proper privileges. I will talk with the DBA later.
>
>> SELECT chain_cnt FROM user_tables WHERE table_name='PARDON';
>>
>> If the number returned is sufficiently large, then you have chained or
>> migrated rows which need fixing.
>
>What would be considered a number sufficiently large?

Anything you determine after you stop symptom fighting and start reading the Performance tuning manual.

--
Sybrand Bakker, Senior Oracle DBA