I have a query which returns instantly, until I add the 'Order By'
clause and order the result with three fields. The query then takes
50 seconds ( The plan stays the same ).

Surely a result set should be ordered afterwards - if not is there a
way the tiboquery can order the result once the 'non-ordered' query
has been executed ?

A related 2nd question - if I get a result set and also want to count
how many records in the result - I see the query is fired again when
I use the recordcount method, replacing the select ... with select
count(*) How can I just count the records of the result ?


Thanks - Rod