Sybase TipsTechnology Tips & Tricks

Sybase IQ Index Tips and Tricks

By August 24, 2012 No Comments

Parallel = the of speed! Sometimes, but in this case it does.

Why on does IQ only allow you to create with parallel option? Ask !

BEGIN PARALLEL
CREATE  index idx_1_ ON <table> (column_1);
CREATE LF index idx_2_LF ON <table> (column_2);
CREATE HG index idx_3_HG ON <table> (column_3);
...... on and on
END PARALLEL

Restricted Access Content

Please Register to View The Entire Content

This content is restricted to site members. You need to login to read the entire article. If you are an existing user, please log in. New users may register here. Registration is FREE and only takes 30 seconds.

Existing Users Log In