This is for PeopleSoft experts.
I see a lot of functional indexes in my PeopleSoft database. This is due to the indexes created on date columns as DESC. Because of these functional indexes, full table scan is being preferred by the optimizer.
Is there any way to get around this problem?
Any help is appreciated.
Please leave your answer/comments.
I see a lot of functional indexes in my PeopleSoft database. This is due to the indexes created on date columns as DESC. Because of these functional indexes, full table scan is being preferred by the optimizer.
Is there any way to get around this problem?
Any help is appreciated.
Please leave your answer/comments.
