Re: WHATS WRONG WITH DBA_TABLES?
From: Ulrike Schomacher;fel <FUN02_at_bertelsmann.de>
Date: 1996/04/17
Message-ID: <4l3321$31j_at_porsche.highway.bertelsmann.de>#1/1
Date: 1996/04/17
Message-ID: <4l3321$31j_at_porsche.highway.bertelsmann.de>#1/1
You have to Analyze the table first, example: ANALYZE table NEW_MARINES estimate statistics;
The analyze command fills columns in the data-dictionary-tables like all_tables. This information is used by the cost-based optimizer.
So Analyze your tables first.
Volker Tiggesbaeumker
tig03_at_Bertelsmann.de
Received on Wed Apr 17 1996 - 00:00:00 CEST