Posted by Erland Sommarskog on 10/24/07 21:15

Enorme Vigenti (LSimon5@libero.it) writes:
> It is more better to migrate at sqlserver2005 for the partitionet tables
> and then use a single day table to create index? In that case I could
> have only one day index! :-)

The main advantage of partitioned tables is that it makes it easy to
age out old data very quickly. I don't see any particular gain for
querying in your case. For the queries a clustered index on the datetime
column would be a good start.

If there are many rows per day (say > 50000), you may need to add non-
clustered indexes as well for the most important queries. Possibly with the
datetime value as the first column.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]