What columns should I review when determining which indexes to add to a database?
- Times Advised for Query Use
- Most Expensive Query Estimate
- Others?
If one row advises to add FieldA , FieldB, and a second row advises FieldA for the same file, would adding a logical file with keys FieldA & FieldB do the trick for both advising rows?
Does creating a LF benefit the same as adding an index?
Thanks
______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit
http://www.symanteccloud.com
______________________________________________________________________
