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 have overflow segment in my IOT, I don't have to "analyze table", just analyze PK?

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


Reply via email to