网站 › 『 Sybase ASE 』 › [求助]SET SHOWPLAN后显示的东西怎么看?

10100101 发表于 2006-7-3 17:35:12

[求助]SET SHOWPLAN后显示的东西怎么看?

<p>1&gt; select * from node where node_id&lt;0<br/>2&gt; go</p><p>QUERY PLAN FOR STATEMENT 1 (at line 1).</p><p>1 operator(s) under root</p><p><br/>The type of query is SELECT.</p><p>ROOT:EMIT Operator</p><p>&nbsp;&nbsp; |SCAN Operator<br/>&nbsp;&nbsp; |&nbsp; FROM TABLE<br/>&nbsp;&nbsp; |&nbsp; node<br/>&nbsp;&nbsp; |&nbsp; Table Scan.<br/>&nbsp;&nbsp; |&nbsp; Forward Scan.<br/>&nbsp;&nbsp; |&nbsp; Positioning at start of table.<br/>&nbsp;&nbsp; |&nbsp; Using I/O Size 8 Kbytes for data pages.<br/>&nbsp;&nbsp; |&nbsp; With LRU Buffer Replacement Strategy for data pages.</p><p>Parse and Compile Time 0.<br/>SQL Server cpu time: 0 ms.</p><p>Execution Time 0.<br/>SQL Server cpu time: 0 ms.&nbsp; SQL Server elapsed time: 3 ms.</p><p>他是怎么扫的?怎么才能看出来用没用到索引??</p><p>如果用到了索引是怎么写的 大家帮看看.</p>

mzd75 发表于 2006-8-9 18:05:28

|&nbsp; Table Scan.<br/>使用的是表扫描，没用到索引，如果用到索引下面会显示索引名字！

查看完整版本: [求助]SET SHOWPLAN后显示的东西怎么看?