on 08-15-2008 2:40 PM
Hello All,
On BW system we are getting warning for unused index.
But index is active on SAP and corresponding table is also active.
I have tried rebuilding and recreating the index but next day it gets unused again in database.
Thanks,
Anu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Got the solution
Hello,
I think if index is unused and even after rebuilding the index if it is getting unused again, then it is no more needed.
Sorry for late reply.
Anu
Markus thanks for the reply.
On SAP index is active. What does that mean?
On database index is unused.
Can we drop that index ?
hi anu,
can i know if you had any solution for the same?
"unused" doesn´t mean it´s not existing - it means just that - those indexes are not (yet) been used to speed up a query.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.