Subject Re: Error Message in SP
Author sasidhardoc
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!