Parallel = the holy grail of speed! Sometimes, but in this case it does.
Why on Earth does IQ only allow you to create indexes with parallel option? Ask Sybase!
CREATE HG index idx_1_HG 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
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.