Subject Re: commit after insert is very slow
Author emb_blaster
> yes i know, and what you do with order by ? when you do a query, with index to choose to use in the plan ? the index on the order by or the index on the filter? to know that you must know BEFORE to do the query the amount of row the filter will return to you !

So you are telling that you ALWAYS choose the index with a "PLAN" statment and never let the FB engine do it for you?