Path: utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!tut.cis.ohio-state.edu!ucbvax!hplabs!nsc!pyramid!infmx!cortesi
From: cortesi@infmx.UUCP (David Cortesi)
Newsgroups: comp.databases
Subject: Re: Informix isql
Keywords: order by, select, entry form, cluster index
Message-ID: <3357@infmx.UUCP>
Date: 12 Feb 90 18:52:40 GMT
References: <6548@uhccux.uhcc.hawaii.edu> <1990Feb11.084522.12120@halexii.uucp>
Reply-To: cortesi@infmx.UUCP (David Cortesi)
Organization: Informix, Menlo Park, Ca. U.S.A.
Lines: 15

In article <1990Feb11.084522.12120@halexii.uucp>
 			greg@halexii.UUCP (Gregory F. Hogg) writes:
>In article <6548@uhccux.uhcc.hawaii.edu>
		richardj@uhccux.UUCP (Richard Jablonka) writes:
>>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
>	As fas as I know there is no way todo what you want in
>INFORMIX-SQL. The best I have been able to do is to unload the table
>ordered the way you want and then reload it.  This way the records are
>in the dbtable allready ordered.

Loading a table in the desired order is the most efficient way, but
to create an ordering or a new ordering after the fact you use the
command CREATE CLUSTER INDEX.  The command ALTER INDEX
is used to refresh the ordering after inserts or updates.