]To:
[EMAIL PROTECTED]
on.com cc:
[EMAIL PROTECTED]
Subject: RE: ora-600
when analyzing IOT
08/07/2003 12:13
PM
Rick
Rick,
Thanks for prompt reply.
I tried it (deleting statistics before analyzing table) and it worked.
Any ideas, whether cost-based optimizer need statistics on IOT or having
statistics on PK index of IOT would be enough?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
]
on.com cc: [EMAIL PROTECTED]
Subject: RE: ora-600 when analyzing
IOT
According to MetaLink you need to delete statistics and re-analyze
I do not know your database version but this is supposely fixed in 8.1.6
execute
Title: RE: ora-600 when analyzing IOT
Only missing data in *_TABLES is avg_row_len which, probably, can be used for estimating hash area for hash join.
Also, columns statistics will not be generated, probably more important.
Alex.
-Original Message-
Does it mean, that if I don't
cc:
Sent by: Subject: RE: ora-600 when analyzing
IOT
[EMAIL PROTECTED
