Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Composite index with datetime field
Message
From
31/07/2007 13:30:41
John Jones
Kuala Lumpur, Malaysia
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Composite index with datetime field
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01244926
Message ID:
01244926
Views:
72
Hi,
I have a composite index which consist of character field, DateTime field, character field.

When I try to select record by using CharField + CAST(DateTimeField AS CHAR(8)) + CharField2 expression, it doesn't seem to be optimized.

Any ideas?

Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Next
Reply
Map
View

Click here to load this message in the networking platform