tag:blogger.com,1999:blog-4646137438366687895.post5020950122401613728..comments2024-03-24T02:48:23.930-07:00Comments on Demystifying SQL Server: The Real SQL Pages, A Beginner’s Guide To IndexingAdam Haineshttp://www.blogger.com/profile/16288608920551626835noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4646137438366687895.post-81348754924995743322009-07-30T13:24:53.899-07:002009-07-30T13:24:53.899-07:00Adam,
Good post. Your example of searching for n...Adam,<br /><br />Good post. Your example of searching for name without the letter is the scenario in which an Oracle "Skip Scan" might apply.<br /><br />Skip scan is useful when the leading edge column of the index is not explicitly involved in the filtering and has a low cardinality -- which would probably be the case here.<br /><br />I am skeptical about how useful skip scans are, but they can be faster than an index "full scan".<br /><br />Once every few years I might coerce a non-production query into simulating a "skip scan" by joining a domain table -- if one is available -- to the target table so that I am now including the first column of the index in the lookup.<br /><br />I cannot think of anytime I have done this with production code. <br /><br />Pure novelty I guess.<br /><br />Kent WaldropKent Waldrophttps://www.blogger.com/profile/11169211720676440554noreply@blogger.comtag:blogger.com,1999:blog-4646137438366687895.post-18568601384455179992009-07-29T06:33:13.002-07:002009-07-29T06:33:13.002-07:00Thanx Adam, i love Back to Basics blog posts.
Eve...Thanx Adam, i love Back to Basics blog posts.<br /><br />Even if it is simple, it can always use review. And who know, maybe something simple was overlooked the first time.<br /><br />Know to (fully) understand clustered vs non-clustered.Brian Tkatchhttps://www.blogger.com/profile/11320700842381820277noreply@blogger.com