× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Tariq Rahiman
tariqrahiman reported 2014-10-14T19:17:06Z  · last modified 2014-11-03T19:29:47Z

Sybase ASE 16 : support Index compression with options { None | Page}


Dev
Ivan Gron
ivangron
QA
Niels Gron
NielsGron
Priority Low
Complexity Unknown
Component App - Visual Editing
Version 16.0

Sybase ASE 16 : support Index compression with options { None | Page }

We need to add a new option in Create / Index Properties Visual Editor for Sybase ASE for index compression. See attached screenshot.
 
An index or index partition can be compressed with the index_compression clause. Parameter Changes for index_compression is below:
 
NONE – the index page for the specified index is not compressed. Indexes that are specifically created with index_compression = PAGE are compressed.
PAGE – when the page is full, existing index rows are compressed using the page prefix compression. When a row is added, a check determines whether the row suitable for compression.
 
To reproduce:
 
drop table foo
go
create table dbo.foo  ( 
id   int ,
name varchar(25)  
)
go
 
create index idx1_foo
    on foo (id, name)  
with index_compression = page
go
 

 

1 attachment
  •  
  •  
  • No shares
  •  
All Comments (2) Change History
Sort 

Issue #12554
Closed
Fixed
Resolved 2014-10-21T21:36:47Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017