An Explain plan is done on a query with a two-digit year Where condition on a partitioned table. Partitioned column has a date criteria and the Explain Plan table returns the "Key" value in the PStart column.
select * from <table name> where <column name> > TO_DATE('01/01/08', 'dd/mm/yy');
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center