RE: Composite index

Dirk NO, best performance would be to go from most unique to least unique or from most selected to least selected. Keith -> -----Original Message----- -> From: Dirk Moolman [mailto:DirkM@mxgroup.co.za] -> Sent: Friday, May 06, 2005 10:43 AM -> To: informix-list@iiug.org -> Subject: Composite index -> -> -> If I have a composite index, I assume that the best performance gain -> would be to create the index in order of column size - -> smallest column -> to biggest column -> -> Create index i1_index on tab1 (col1, col2, col3) -> -> Where col1 is the smallest, and col3 the largest. -> -> -> -> Is my assumption correct ? -> -> -> -> -> -> Dirk Moolman -> Database and Unix Administrator -> HEALTHCORP -> -> -> -> "People demand freedom of speech as a compensation for the freedom of -> thought which they seldom use." -> -> -> sending to informix-list -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list