/* ************************************************ */
/*                                                  */
/* Author            : Rick Kupcunas                */
/*                   : rick@kupcunas.com            */
/* Name		     : qep_1.sql                    */
/* Original          : 2003-Jan-01                  */
/*                                                  */
/* This script will build the explain plan table    */
/*                                                  */
/* Note: run as the "system" user                   */
/*                                                  */
/* ************************************************ */

create table PLAN_TABLE
    (statement_id          varchar2(30),
     timestamp             date,
     remarks               varchar2(80),
     operation             varchar2(30),
     options               varchar2(30),
     object_node           varchar2(30),
     object_owner          varchar2(30),
     object_name           varchar2(30),
     object_instance       numeric, 
     object_type           varchar2(30),
     search_columns        numeric,
     id                    numeric,
     parent_id             numeric,
     position              numeric,
     other                 long);

drop public synonym plan_table;
create public synonym plan_table for plan_table;
 
commit;




