Path: utzoo!attcan!uunet!cs.utexas.edu!asuvax!anasaz!john
From: john@anasaz.UUCP (John Moore)
Newsgroups: comp.databases
Subject: Re: Informix isql
Message-ID: <1296@anasaz.UUCP>
Date: 13 Feb 90 14:21:58 GMT
References: <6548@uhccux.uhcc.hawaii.edu> <1990Feb12.162507.612@aqdata.uucp>
Reply-To: john@anasaz.UUCP (John Moore)
Organization: Anasazi, Inc.
Lines: 26

In article <1990Feb12.162507.612@aqdata.uucp> sullivan@aqdata.uucp (Michael T. Sullivan) writes:
]From article <6548@uhccux.uhcc.hawaii.edu>, by richardj@uhccux.uhcc.hawaii.edu (Richard Jablonka):
]> 
]> I want to SORT an informix table.  I only need to do it once.  The problem is 
]> making the names come up in the right order in an entry form.   Unfortunately
]> in an entry form you can only state the table name and you can't use the where
]> or order by clause.
]
]My guess is that you index the order you want and make that a clustering
]index.  Since perform appears to show rows in their raw table order, this
]will probably do what you want.
]-- 

Informix has "implicit order-by." If you have an index on the table,
and you force it to use the index by including a reference to it
in the WHERE clause, it will return the rows in order of the index,
even without an order-by clause.

If you really want the raw table sorted, the act of creating a
CLUSTERED index does a physical sort on the table. 

-- 
John Moore (NJ7E)           mcdphx!anasaz!john asuvax!anasaz!john
(602) 951-9326 (day or eve) long palladium, short petroleum
7525 Clearwater Pkwy, Scottsdale, AZ 85253
Support ALL of the bill of rights, INCLUDING the 2nd amendment!