stored outline issue
Hi experts,
i have an issues with stored outlines.i am on oracle 9.2.0.1
i created and outline as
CREATE OR REPLACE OUTLINE JOB1 FOR CATEGORY JOB_TBL2 ON
SELECT EMPLID FROM PS_JOB WHERE ACTION LIKE :1
then
ALTER SESSION SET use_stored_outlines=JOB_TBL2;
after that if i run the query SELECT EMPLID FROM PS_JOB WHERE ACTION LIKE :1 then my stored outline is used
but if i run as SELECT EMPLID FROM PS_JOB WHERE ACTION LIKE 'HIR' it doesnot use stored outline.
cursor sharing is similar.
Please help.
i have an issues with stored outlines.i am on oracle 9.2.0.1
i created and outline as
CREATE OR REPLACE OUTLINE JOB1 FOR CATEGORY JOB_TBL2 ON
SELECT EMPLID FROM PS_JOB WHERE ACTION LIKE :1
then
ALTER SESSION SET use_stored_outlines=JOB_TBL2;
after that if i run the query SELECT EMPLID FROM PS_JOB WHERE ACTION LIKE :1 then my stored outline is used
but if i run as SELECT EMPLID FROM PS_JOB WHERE ACTION LIKE 'HIR' it doesnot use stored outline.
cursor sharing is similar.
Please help.
0