Sybase ASE 入門 SQLチューニング

• set showplan on でクエリプランを表示する

1> set showplan on
2> go

QUERY PLAN FOR STATEMENT 1 (at line 1).


    STEP 1
        The type of query is SET OPTION ON.

1> select * from t1
2> go

QUERY PLAN FOR STATEMENT 1 (at line 1).
Optimized using Serial Mode


    STEP 1
        The type of query is SELECT.

        1 operator(s) under root

       |ROOT:EMIT Operator (VA = 1)
       |
       |   |SCAN Operator (VA = 0)
       |   |  FROM TABLE
       |   |  t1
       |   |  Table Scan.
       |   |  Forward Scan.
       |   |  Positioning at start of table.
       |   |  Using I/O Size 4 Kbytes for data pages.
       |   |  With LRU Buffer Replacement Strategy for data pages.

• http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01079.1570/html/title.htm

• Sybase ASE 入門 目次