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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx