Re: ORDER BY within REPORT routine

Ian Clark wrote: > > What I would like to know is in what circumstances should I consider > using the ORDER BY statement within the REPORT routine? Would the > report be produced any quicker, is it more efficient and is it any > easier? Peter Lancashire wrote: > > I think it is there mainly for use with ASCII file input. I'd guess the > engine would be better just about every time. I haven't tested it, > though. The big difference is that the report can not take advantage of any indexes that the engine might. However, performing sorts within the report does take a load off the engine, which is often preferable. -Richard