Index compression info omitted in SSMS Index Editor and CREATE INDEX scripts - by A. Tolmeijer

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 776210 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/10/2013 3:02:01 AM
Access Restriction Public

Description

An index is compressed as follows:
ALTER INDEX [nx_myTable] ON [dbo].[myTable]
REBUILD PARTITION = ALL WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF
                                                      , SORT_IN_TEMPDB = OFF, ONLINE = OFF
                                                      , ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON
                                                      , DATA_COMPRESSION = PAGE)

GO

When looking at then index editor in SSMS, I see no indication that the index is, or can be, compressed. Also, when I generate a CREATE INDEX script, it omits the compression option:

/****** Object:  Index [nx_myTable]    Script Date: 10-1-2013 11:45:34 ******/
CREATE NONCLUSTERED INDEX [nx_myTable] ON [dbo].[myTable]
(
	[code_customer] ASC,
	[code_product] ASC,
	[code_structure] ASC,
	[code_collaborateur] ASC,
	[date_event] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

Please fix!
Sign in to post a comment.
Posted by Alex [MSFT] on 1/29/2013 at 1:43 PM
Hello

We took a look at this bug along with several others recently.
Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the nea
r future.
However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

Thanks for writing in to Microsoft.
Alex Grach[MSFT]