ТЕМА:

INDEX_NAME  TABLE_NAME  COLUMN_NAME     COLUMN_POSITION DESCEND
----------- ----------- --------------- --------------- -------
DOCUM_I1    DOCUM       DATA            1               ASC
DOCUM_I1    DOCUM       ACCOUNT_ID      2               ASC
DOCUM_I2    DOCUM       DATA            1               ASC
DOCUM_I2    DOCUM       LEDGER_ID       2               ASC
DOCUM_I2    DOCUM       VAL_ID          3               ASC
DOCUM_I2    DOCUM       SUBLEDGER_ID    4               ASC
DOCUM_I2    DOCUM       CLIENT_ID       5               ASC
DOCUM_I3    DOCUM       DATA            1               ASC
DOCUM_I3    DOCUM       FORMA_ID        2               ASC
 

 
-- Create table
create table DOCUM
(
  DATA             DATE not null,
  ACCOUNT_ID       NUMBER not null,
  CLIENT_ID        NUMBER not null,
  LEDGER_ID        NUMBER not null,
  VAL_ID           NUMBER not null,
  SUBLEDGER_ID     NUMBER not null,
  AMOUNT           NUMBER default 0 not null,
  FORMA_ID         NUMBER
)
tablespace DOCUM_TBS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  ); 

SQL> explain plan for
  2  
  2  select account_id, sum(amount)
  3    from docum
  4   where data >= '01jan2011'
  5   group by account_id
  6  ;
 
Explained
 
SQL> select * from table(dbms_xplan.display);
 
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 2294080508
-----------------------------------------------------------
| Id  | Operation                    | Name               |
-----------------------------------------------------------
|   0 | SELECT STATEMENT             |                    |
|   1 |  SORT GROUP BY               |                    |
|   2 |   TABLE ACCESS BY INDEX ROWID| DOCUM              |
|*  3 |    INDEX RANGE SCAN          | DOCUM_I3           |
-----------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
   3 - access("DATA">='01jan2011')
Note
-----
   - rule based optimizer used (consider using cbo)
 
19 rows selected
 
SQL>