very urgent - INDEXING/REINDEX [message #76054] |
Mon, 23 June 2003 01:51 |
shareef
Messages: 72 Registered: November 2002
|
Member |
|
|
HELLO EVERY ONE
I HAVE TOO OLD AND HUGE INDEXES. DOING REINDEX FOR THOSE INDEXES MAKE MY DATABASE ANY EFFECT OR NOT?
I MEAN THE TRANSECTIONS EXECUTION BECOMES FASTER OR NOT.
ANY RESPONCE IN NAGITIVE WILL BE APPRICATE AND THANKS IN ADVANCE.
REGARDS
SHAREEF
|
|
|
Re: very urgent - INDEXING/REINDEX [message #76175 is a reply to message #76054] |
Fri, 14 January 2005 19:40 |
Stephen
Messages: 26 Registered: January 2000
|
Junior Member |
|
|
Hi shareef ,
Surely the Re-indexing improves the transactions performance. I have seen implementing this concept in our client place by our DBA.So go ahead do Re-indexing.
Could you please send me the steps to re-index the database because I aslo want learn that.
Regards
stephen
|
|
|