Rao_S
asked on
Can monitoring an Index cause an overhead?
Can monitoring an Index cause an on the table..? If something like this..is defined on the table where index in question is a partitioned index?
ALTER INDEX XXXXX01.XQT_IT_YYYYYY_SEQ_ N7
MONITORING USAGE;
ALTER INDEX XXXXX01.XQT_IT_YYYYYY_SEQ_
MONITORING USAGE;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
if a index is not being used at all and if it exits, then just the existence of the index is an overhead..?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i have attached an file ..where i was trying a query to check if N6 index is being used... let me know what you think....
ASKER
sorry here is the file.... index-check.txt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
your plan shows the n6 index isn't used in this particularly query, but that doesn't mean it's not used somewhere else in the application
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you all!!!
ASKER