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>
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