Clustered Index Scan and Clustered Index Seek
Clustered Index Scan and Clustered Index Seek for Clustered Index :
Index Seek means that SQL Server will traverse the index from the root down to the leaf level, comparing
the values in the SARG to the key values in the index rows to determine which page to look at next. Seeking
through an index typically means a root-to-leaf traversal.
Index scan, the alternative to Index Seek, means that SQL Server will stay at the leaf level and traverse just that
one level of the index from the first page to the last. I like to think of a seek as a vertical traversal of an
index and a scan as a horizontal traversal. Remember that for a clustered index, the leaf level of the index is
the table data itself, so scanning the clustered index really means scanning the table. In fact, the only time you'll
see Table Scan as an operator in the plan is for heaps.
Clustered Index Scan 相當於全表掃描
Clustered Index Seek 相當於索引掃描
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-600856/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 資料庫表--index clustered table資料庫Index
- 簇表及簇表管理(Index clustered tables)Index
- INDEX UNIQUE SCAN,INDEX FULL SCAN和INDEX FAST FULL SCANIndexAST
- rowid,index,INDEX FULL SCAN,INDEX FAST FULL SCAN|IndexAST
- Index Full Scan vs Index Fast Full ScanIndexAST
- Index Full Scan 與 Index Fast Full ScanIndexAST
- Index的掃描方式:index full scan/index fast full scanIndexAST
- index range scan,index fast full scan,index skip scan發生的條件IndexAST
- INDEX FULL SCAN和INDEX FAST FULL SCAN區別IndexAST
- index full scan 和 index FAST full scan 區別IndexAST
- Index Full Scan 與 Index Fast Full Scan (Final)IndexAST
- INDEX SKIP SCANIndex
- INDEX FULL SCAN和INDEX FAST FULL SCAN的區別IndexAST
- index full scan 和 index fast full scan (IFS,FFS)的不同IndexAST
- 理解index skip scanIndex
- Index Unique Scan (213)Index
- PostgreSQL DBA(119) - pgAdmin(LIMIT:Index Scan vs Bitmap Index Scan)SQLMITIndex
- Index Full Scan和Index Fast Full Scan行為差異分析(上)IndexAST
- Index Full Scan和Index Fast Full Scan行為差異分析(下)IndexAST
- [轉貼]Skip Scan IndexIndex
- 關於INDEX SKIP SCANIndex
- Index Range Scan (214)Index
- [總結]關於index range scans & INDEX (FAST FULL SCAN)IndexAST
- index fast full scan 和 nullIndexASTNull
- Fast full index scan 淺析ASTIndex
- 索引優化index skip scan索引優化Index
- 收集full table / index scan sqlIndexSQL
- 資料庫表--hash clustered table資料庫
- INDEX SKIP SCAN適用場景Index
- mysql loose index scan的實現MySqlIndex
- 資料庫表--sorted hash clustered table資料庫
- oracle index unique scan/index range scan和mysql range/const/ref/eq_ref的區別OracleIndexMySql
- Oracle vs PostgreSQL Develop(31) - Index Only ScanOracleSQLdevIndex
- Index Range Scan成本與10053Index
- oracle hint_skip scan_index_ssOracleIndex
- FBI? MAX? INDEX FULL SCAN (MIN/MAX)?Index
- Understanding HTTP plug-in failover in a clustered environmentHTTPAI
- MYSQL 中的GROUP BY 的方式 (1)(loose index scan鬆散掃描 tight index scan緊湊掃描)MySqlIndex