http://sqlblog.com/blogs/joe_chang/archive/tags/Query+Optimizer/Engine/default.aspxTags: Query Optimizer, EngineenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/joe_chang/archive/2011/06/13/oracle-index-skip-scan.aspxMon, 13 Jun 2011 03:55:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:36189jchang4http://sqlblog.com/blogs/joe_chang/comments/36189.aspxhttp://sqlblog.com/blogs/joe_chang/commentrss.aspx?PostID=36189There is a feature, called index skip scan that has been in Oracle since version 9i. When I across this, it seemed like a very clever trick, but not a critical capability. More recently, I have been advocating DW on SSD in approrpiate situations, and...(<a href="http://sqlblog.com/blogs/joe_chang/archive/2011/06/13/oracle-index-skip-scan.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=36189" width="1" height="1">EngineQuery Optimizer