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