August 18, 2009 at 7:49 am
How can i alter( need a add a column) an existing index which may be currently in use. I was thinking only drop and recreate index with new column.
Is there a way to alter and does it really effects if someone is already using the index.
Also I want to check the difference in index size after and before adding the new column, how can i do that?
when i do this i get 2 sizes, what doeis that mean?
SELECT name,RESERVED * 8
FROM sysindexes
WHERE NAME= 'index_empcode'
Result:
index_empcode5036808
index_empcode3697912
August 18, 2009 at 8:10 am
you can use ALTER INDEX.... WITH DROP EXISTING
however all this does is drop the exising index and re-create
if anyone is using the index at the time then the command will be blocked. In addition, your command will block other users
how many rows are in the table you wish to create an index on ?
MVDBA
August 18, 2009 at 8:15 am
sp_spaceused. Shows you how much space is taken up by your indexes.
The probability of survival is inversely proportional to the angle of arrival.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply