How do you know you have no statistics?
What does
select table_name, num_rows, last_analyzed
from user_tables;
give you?
Also, setting TIMED_STATISTICS and SQL_TRACE has nothing to do with
running ANALYZE TABLE...
-Joe
--- [EMAIL PROTECTED] wrote:
Hi gurus,
I have analyzed my table A
Moses - What were you expecting? ANALYZE will produce nothing at the
terminal, when it completes it just returns the cursor. Try this:
select last_analyzed from user_tables where table_name = 'A';
You should see the date that you performed the analysis. The main reason you
analyze tables is
I don't get any results when I run the query provided. I have done this but
all I get are results for other tables otherthan table A. The analyze has
gone on for 24 hours.
-Original Message-
Sent: Tuesday, October 15, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
Moses - What
You will see statistics only after the ANALYZE is completed.
8 million records certainly shouldn't take 24hours, though.
Try doing an ANALYZE with a SAMPLE or ESTIMATE. Better, use DBMS_STATS.
At 06:49 AM 15-10-02 -0800, you wrote:
I don't get any results when I run the query provided. I have
Moses - Ah, another clue. Yes, no results provided until the analyze
completes. Your problem isn't getting results, but getting the analyze to
complete. Analyze also sorts the data, so your TEMP file is probably
getting hit like crazy also. Kill that command. Try again with ANALYZE TABLE
A
Thank gurus, Will take a sample rows.
-Original Message-
Sent: Tuesday, October 15, 2002 6:34 PM
To: Multiple recipients of list ORACLE-L
Moses - Ah, another clue. Yes, no results provided until the analyze
completes. Your problem isn't getting results, but getting the analyze to
