Re: [GENERAL] How to avoid using sequential scan

2007-02-12 Thread Richard Huxton
Victor Adolfsson wrote: Hi My query is using a sequential scan and not an index scan even though that I have indexes defined on the foreign keys. This cases my query to take a long long time (10750.687 ms) when it should have been completed in less than 1 second. Any ideas on what may be the c

[GENERAL] How to avoid using sequential scan

2007-02-12 Thread Victor Adolfsson
Hi My query is using a sequential scan and not an index scan even though that I have indexes defined on the foreign keys. This cases my query to take a long long time (10750.687 ms) when it should have been completed in less than 1 second. Any ideas on what may be the cause of this? I have done a