indexes works fine at select statement .. but makes query hang if indexed column is used at the whe
We have upgraded our database from 11.1.0.7 to 11.2.0.4 and since we have done the upgrade, we are facing so many problem with a lot of indexes .. queries go to bad performance and consume server CPU resources and never returning data .. i can specify that indexed column is the problem .. when it used at the where condition .. we altered some Indexes to be INVISIBLE but this work around does NOT succeeded everywhere ..
(Kindly find below example query)
---------------------------------
/* Formatted on 2017/10/25 11:46 (Formatter Plus v4.8.8) */
SELECT xxsa_coupons1.quantity, customer_category
FROM xxsa_coupons xxsa_coupons1,
xxsa_sales_order xxsa_sales_order1,
xxsa_items xxsa_items1,
Tagged:
0