set echo on;
set feedback on;
set pagesize 1000;
set linesize 131;
/* ************************************************ */
/*                                                  */
/* Author            : Rick Kupcunas                */
/*                   : rick@kupcunas.com            */
/* Run: @C:\rkupcuna05_ora\OracleDBA\SQL\qep_2.sql  */
/* Original          : 2009-Jan-01                  */
/*                                                  */
/* This script will:                                */
/*   Populate the qep table for the sql debugging   */
/*                                                  */
/* To run perform the following:                    */
/*  1. replace my initials 'RWK' with your initials */
/*  2. replace the "SELECT..." statement with the   */
/*     SQL you are trying to debug                  */
/*                                                  */
/* Note: run as the "system" user                   */
/*                                                  */
/* ************************************************ */

delete from PLAN_TABLE where statement_id = 'RWK';

explain plan set statement_id = 'RWK'  
into PLAN_TABLE for                    
SELECT supplier_id, UPPER_DESCRIPTION
FROM   MV_VinimayaSearch_all
WHERE  UPPER_DESCRIPTION like '%CHAIR%'and SUPPLIER_ID >0 and Supplier_Id < 1000;




commit;
