> Hi Arnon... Tom's article only talks about INDEX and not ORDER BY. > I would like to do something like this: > USE VIEW myview > ORDER BY fld_name > I know you can not do that.. I thought you ment SET ORDER TO..sorry why do you need to phsically re-ORDER (ie except the order in the original SQL statement) as views should have small subsets (or even incoplete subsets if you are using "retrieve as needed") I see no reason to do that Arnon