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

=?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

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

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

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. However the program is r