Whoa! This really heated up people. It seems there are a lot of people out with comments about this. But the recommendation by Ali Asghar is right on with our in-house experiment.
Microsoft recommends an index on a BIT column, especially in SQL 2K5. Our tables where we have opted for BIT columns, the data distribution ratio is 97:3. We created a non-clustered index and studying the execution plan, we can see a performance gain of 20% VS table scan. Ergo, index that column!
Thank you Ali and Adeel for your detailed insight :-)
If anyone wants the script for the test environment, feel free to contact us.
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment