The following bug has been logged online: Bug reference: 4690 Logged by: vikas Email address: vikas.du...@newgen.co.in PostgreSQL version: PostgreSQL 7.3 Operating system: i686-pc-linux-gnu Description: an select query is not using the index Details:
hi there is a table PDBFolder whose one column is Parentfolderindex on which an index 'idx_folder_parentfolderindex' is created. when i execute the following query Select ParentFolderIndex From PDBFolder Where ParentFolderIndex In ( Select FolderId From FolderTree Where Leaf = 1::int4 ) it takes approximately 10 minutes and when i see the query execution plan of this query it shows sequence scan on pdbfolder(which contain 50,000 rows). can you suggest there is any way to use index idx_folder_parentfolderindex in above query regards Vikas Dubey -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
