Subject Re: best way to set statistics index on new database
Author Bill Oliver
Thanks Ann, Martijn,

> But for a newly created database, why build indexes incrementally
> then set statistics, when creating indexes after the data is loaded
> is faster, builds better indexes, and gets the statistics right
> automatically?

I suppose the user finds it more logical to submit all of the DDL
first and create the data model up front.

If you used a data modeling tool like Erwin, you would get an output
SQL file that would have the tables and indexes created in one place.