Re: [GENERAL] How can I check if my cursor statement is using index

2005-09-29 Thread Tom Lane
=?UTF-8?B?RHJhZ2FuIE1hdGnEhw==?= <[EMAIL PROTECTED]> writes: > I have a program that reads data from Postgresql database (version > 8.0.3) through ODBC, but data retrieval is pretty slow. When I type the > same SQL sentence in pgadmin III or any other sql tool it is much > faster, and typing 'ex

Re: [GENERAL] How can I check if my cursor statement is using index

2005-09-29 Thread Dragan Matić
Dragan Matić wrote: I have a program that reads data from Postgresql database (version 8.0.3) through ODBC, but data retrieval is pretty slow. When I type the same SQL sentence in pgadmin III or any other sql tool it is much faster, and typing 'explain' clearly shows that it is using index. Ho