rp0428 wrote:Ain't the default broke?
I was discussing with a friend about collecting statistics with histogram, if it worth spend time studying the table, its queries and where predicates or if the performance gains worth the spent time.
If it ain't broke don't fix it.
rp0428 wrote:From the OP:
Ain't the default broke?
I have no idea. OP did not say what version of Oracle or what settings, default or otherwise, are being used.
Checking the documentation, the default statistics gathering method for 10g and onwards is FOR ALL COLUMNS SIZE AUTO, so, it gets some workload to calculate the statistics, unlike the 9i version, which uses FOR ALL COLUMNS SIZE 1.Don't a lot of people think the 10g default is broke? Isn't the more fundamental problem trying to munge OLTP and DSS and DW together into one db?