SQL Access Advisor Quick Task

1. Create and run quick task

BEGIN

  dbms_advisor.quick_tune(dbms_advisor.sqlaccess_advisor,

                                   'SAA:a3hvjhf57w6qw',

                                   'SELECT * from TABLE where COLUMN < 0');

   END;

   /

PL/SQL procedure successfully completed.

2. View results

SQL> select dbms_advisor.get_task_script('SAA:a3hvjhf57w6qw') FROM dual; 

DBMS_ADVISOR.GET_TASK_SCRIPT('SAA:A3HVJHF57W6QW')

--------------------------------------------------------------------------------

Rem  SQL Access Advisor: Version 10.2.0.5.0 - Production

Rem

Rem  Username:        SYS

Rem  Task:            SAA:a3hvjhf57w6qw

Rem  Execution date:  16/10/2012 20:02

Rem

CREATE INDEX "USER"."TABLE_IDX$$_413F0001"

    ON "USER"."TABLE"

    ("COLUMN")

    COMPUTE STATISTICS;