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');
Workaround 1:
Use a four-digit year in the Where condition:
select * from <table name> where <column name> > TO_DATE('01/01/2008', 'dd/mm/yyyy');
Workaround 2:
1. Close Toad
2. Copy the attached file and replace the existing file under C:\Documents and Settings\<user name>\Application Data\Quest Software\Toad for Oracle\9.7\User Files folder. Explain Plan will show "Partitions determined by Key values" when using a two digit year.
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center