Informx-SE (7.13) Basic DBA question
Asim,
The command,
CREATE INDEX INDEX_NAME ON TABLE_NAME(COL_NAME)will create a Non-Clustered Index. If you wand to create a Clustered
index, the SQL will be,
CREATE CLUSTER INDEX INDEX_NAME ON TABLE_NAME(COL_NAME)
Sanjit
Phone : 91-33-3214890
E-mail: sanjit@ccu-sn.in.dhl.com
************************ START OF FORWARDED MESSAGE **********************
>From : x>aaBubba@yahoo.com
To : informix-list@iiug.org
Subject : Informx-SE (7.13) Basic DBA question
Date : 25/04/98 07:02
If I issue :
CREATE INDEX INDEX_NAME ON TABLE_NAME(COL_NAME)
command, would this be a Clustered Index or Non-Clustered ??
TIA
-asim