Database version: Informix-12.10
ADS version: ads-windows-x86-14.0-rc-44
Connect Informix
Create simple index
CREATE INDEX informix.TEST_ALTER_INDEX ON informix.nilesh(col1, col3, col2)
Go to Index Tree nodes right click ->Select Index->Right click on Index->Select Alter Index->Go to Options Tab->Both Unique and Clustered options are Disabled.
Now open Query analyzer window->write Alter query for Index->
ALTER INDEX informix.index2 TO CLUSTER;
Execute this query->it alters Index successfully.
|
506 KB
Issue #10378 |
Closed |
Completion |
No due date |
No fixed build |
No time estimate |