Statistics

From: Patrice LENOIR <patrice.lenoir_at_eurotunnel.com>
Date: 28 Jan 2003 11:17:04 -0800
Message-ID: <28470373.0301281117.74ef593b_at_posting.google.com>


Hi

I wonder if when i do an analyze with compute methode on a table, i need to do it also for the indexed columns with the "for all indexed columns".

I understand that this clause (for all indexed columns) update the histograms, but does an analyze table schema.table_name compute statistics done it?.

Thank's.

Patrice Received on Tue Jan 28 2003 - 20:17:04 CET

Original text of this message