index reorganize

[maswien]

In SQL Server 2005, the syntax for index reorganize is awful.

it's like:

alter index <index name> on <table name>.<column name> reorganize

I tried to first detect the fragmented index and then using alter index ... reorg ... to defrag them. But this weird syntax blocks me. Is it necessary to specify the column name if I just want reorganize it???

 

[maswien]

Sorry microsoft!, my mistake, the syntax is:


alter index <index name> on <table name> reorganize