Subject | Re: Error Message in SP |
---|---|
Author | sasidhardoc |
Post date | 2007-04-25T06:37:34Z |
ODS 11.0 and dialect 3
I was planning on adding an INDEX as:
CREATE ASC INDEX I_PIM_APPOINTMENTS_MONTH ON PIM_APPOINTMENTS COMPUTED
BY (EXTRACT (MONTH FROM CAST (APPOINTMENT_STARTTIME AS DATE)));
Since APPOINTMENT_STARTTIME has virtually no duplicate entries. Is
that a good idea? thanks!
I was planning on adding an INDEX as:
CREATE ASC INDEX I_PIM_APPOINTMENTS_MONTH ON PIM_APPOINTMENTS COMPUTED
BY (EXTRACT (MONTH FROM CAST (APPOINTMENT_STARTTIME AS DATE)));
Since APPOINTMENT_STARTTIME has virtually no duplicate entries. Is
that a good idea? thanks!