Is it good to use PARALLEL hint for OLTP system?
We had a query which is giving poor response time when we query it for a particular status records from a status column. The index on the other column of the table which is having the status column is being used, which is fine when we query for the records not filtering with status. But if we want to go for filtering with status it is not using the index on the status column. Only option we have is to force the index on the status column through the hint, which is not feasible as this is a report and different