You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query Slower after patch Favoring Full Table Scan (FTS) instead of Index Scan

Received Response


A report built to get the timecard details (OTL query) is suddenly running for a very long time after the recent patch was applied. It does full table scan rather than index scan, is there any way to resolve this. This used to take 30 mins prior to the patch, now it keeps running over an hour

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!