Recently while troubleshooting performance issues on our Production system,
our DBA team has identified some unused indexes on T2356 (HPD:Help Desk
form) and suggested us removing them could improve the query performance
and clean up some space in the Database. We have verified the same from
From what I can tell of the table you provided -- none of the indexes are
being used.
So - deleting them would have no affect.
Except (and this is a stretch) ... not having these indexes exist means
more memory available to put other indexes into memory. (But - I doubt that
is an issue here).
Hi ,
Can you please let me if there will be any impact if we remove the OTB defined
indexes from the OTB form?
Regards
Madhu
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have
Whatever was defined in their workflow that was going to utilize that index
won't be able to and performance could suffer as a result.
On May 28, 2015 3:07 AM, Madhu V madhu.pesronalandpriv...@gmail.com
wrote:
Hi ,
Can you please let me if there will be any impact if we remove the OTB
defined
Well - if it is a unique index - you will make swiss cheese of your system.
I would suggest - don’t delete the index.
I will ask you a question in return:
What benefits do you see in removing an OTB index?
-John
On Thu, May 28, 2015 at 4:07 AM, Madhu V madhu.pesronalandpriv...@gmail.com
Some DBAs want to manage indexes from the DB level, and so they recreate
them there. That *can* increase performance, but from that point, all
maintenance of indexes must occur at the DB level. Apart from that, I
don't know why one would remove indexes from a form, unless it's a form no
one
6 matches
Mail list logo