On Wed, Dec 22, 2004 at 18:44:00 +0100, "Együd Csaba (Freemail)" <[EMAIL PROTECTED]> wrote: > But why? I thought the planner is for choose the quicker way to the target > point. If there is an index which is probably would speed up the query then > why does the planner ignore that?
Because doing an index scan is slower if you are retrieving a significant (very roughly 5%) fraction of a table. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly