| Subject | Re: best way to set statistics index on new database | 
|---|---|
| Author | Bill Oliver | 
| Post date | 2007-08-22T15:32:21Z | 
Thanks Ann, Martijn,
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.
-bill
            >I suppose the user finds it more logical to submit all of the DDL
> 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?
>
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.
-bill