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