J
James Palmer
Guest
Any query predicate that uses a NOT or a NE will cause trouble with index selection and reads. This isn't the most super-technical in-depth analysis of query selection or anything, but it's got lots of guidelines and gotchas to watch out for. www.jdpalmer.co.uk/.../index.php Most importantly it includes methods for finding out which indexes are selected, and for finding out records read by the query.
Continue reading...
Continue reading...