how to tell a select statement to ignore an index?
Dear All,
I have a big query that uses many indexes, but when i create a new index on the table accessed by the query, the query will try to use that additional index and so it performs badly. Can you tell me how to tell this query to ignore this index, because I need the index in other queries and I can't drop it.
Regards
Wassim