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');
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center