"Richard Hartland" <[EMAIL PROTECTED]> wrote: > The +asc in the order by is not being recognized as correct syntax. I am > unfamiliar with using the + operator in this way - what does it do? > > > I'm guessing it might go faster if you (1) run ANALYZE first or > (2) record the ORDER BY clause to say: "S.SortID +asc".
I should have said: "+S.SortID asc" -- D. Richard Hipp <[EMAIL PROTECTED]>
