|
|
Posted by Enorme Vigenti on 10/24/07 07:07
Erland Sommarskog ha scritto:
> How selective is the datetime column? If all queries are for a single
> day, maybe an index on that column is sufficient, preferrably a clustered
> index.
>
> But if queries can be for longer periods of time, that may address too many
> rows, and in such case you will need to add more indexes. How these indexes
> should be designed depends on the queries. If a query can be on account
> number and a date interval, it's probably better to have the account number
> first in that index.
tnx 4 answer :-)
datetime column is much selective because every night I must exec
day-statistical report. I must make hour statistical report too (but it
is another type of report).
The queryes is always on datetime field and then for other some fileds.
but it is for day after only! (I must keep one month)
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! :-)
bye
Navigation:
[Reply to this message]
|