79666870

Date: 2025-06-15 21:21:48
Score: 2
Natty:
Report link

If you from Microsoft, please ask for feature request for simple tables and indexes moving between filegroups.
Main idea:
- use syntax without fields enumeration because MSSQL engine already knows them;
- commands same for indexes, tables, heaps.

SAMPLE:

alter table heaptable rebuild on FG (with online on|off, maxdop = nn)

alter index clu_index rebuild on FG

alter index nonclu_index rebuild on FG

-----------
oracle, postgress, mysql already have these commands. mssql does not.

Reasons:
  • No code block (0.5):
  • Filler text (0.5): -----------
  • Low reputation (1):
Posted by: Andrey i