On 03/20/2012 08:54 PM, Brent Wood wrote:
>
> Also look at a clustered index on timestamp
>
>
> Brent Wood
>
> GIS/DBA consultant
> NIWA
> +64 (4) 4 386-0300
A clustered index is only "clustered" at the point in time you run the command. It wont remain that way, and with a
reallybig table, you don't wanna spend the time re-clustering it every time you import more data.
-Andy