Subject Re: [firebird-support] Re: Query plans and joins
Author Martijn Tonies
Hello Filip,

> > Actually, try a "fetch all" and see which one is slower.
> Sure, i agree when doing a "fetch all" performance won't differ that
> much but that's what i'm trying to avoid. I don't want them all "at
> once" and the additional sort forces the "fetch all" on the server side.

Then don't ask for them "all at once" :-)

Seriously, you're asking the server for a complete resultset which
needs to be prepared.

In general, I look to indices for quick lookups, not for sorting. If
a sort can use an index, that's - usually - an added benefit, but not
at all the "normal" way of things.

> BTW: Is Arno still running his Dutch FireBird newsgroup?

He sure does.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!