Skip to Content
0
Former Member
Jul 10, 2008 at 05:14 AM

Index not used on a certain selection criteria on ST05

25 Views

Hi Gurus,

I made a customized calendar month infoObject as index for my ODS. When I try to run a query from that ODS using calendar month value 08/2008, the performance is Ok. But when I try to run the query using 07/2007 as selection criteria, the performance to retrieve the data was so slow.

I try to run an SQL Trace (ST05) on both selection criteria. I found out that the SQL trace for 08/2008 compose of PREPARE, OPEN and then FETCH while for 07/2007 compose only of FETCH.

I think the index wasn't used by 07/2007 while the index was used by 08/2008. However both criteria's execution plan showing that they used the index.

Kindly response on this message with resolution/s if someone encounters the same issue.

Thanks and regards,

Raymond