|
-
Sep 30th, 2010, 07:44 AM
#1
Thread Starter
Hyperactive Member
What columns to index?
Hi,
I have the following table called AssetMeterReading.
AssetMeterReading
------------------
ReadingID - PK - Indexed
AssetID
Reading
Date
------------------
A lot of my serialized transactions access this table to validate meter readings.
What Columns should I index? I put two seperate indexes on the AssetID and Date a few days back. Today I got a DeadLock error (haven't got one before). Would my indexing have caused the deadlock.
It is the mark of an instructed mind to rest satisfied with the degree of precision which the nature of the subject admits, and not to seek exactness when only an approximation of the truth is possible.
-Aristotle As quoted in Rapid Development, chapter 8, page 167.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote