I need to gather all the applicable options and their values that could have been used on an index during creation/alteration.
Does anyone know what system tables may hold the information concerning the following create index options:
1) ONLINE
2) MAXDOP
3) STATISTICS_NORECOMPUTE
4) DROP EXISTING
Does anyone know what system tables may hold the information concerning the following create index options:
1) ONLINE
2) MAXDOP
3) STATISTICS_NORECOMPUTE
4) DROP EXISTING