IN Qeury Problem
От | Sameer Maggon |
---|---|
Тема | IN Qeury Problem |
Дата | |
Msg-id | PIEELGOGLBEAPIHJAMIDEEMHCHAA.maggon@newgen.co.in обсуждение исходный текст |
Ответы |
Re: IN Qeury Problem
Re: IN Qeury Problem |
Список | pgsql-sql |
Hello, I am facing a problem regarding the performance of postgres. I am concerned about the speed of the execution of a query when large number of entries is given in the IN clause. I have a Table with columns: FolderName (Indexed) FolderIndex (Indexed) ParentFolderIndex (Indexed) ... .. I have a query where i do a SELECT SELECT * FROM FolderTable WHERE PARENTFOLDERINDEX IN (38::int8, ......); If the number of values in IN clause is small, its working fine, but as and when the number of values increases the speed of the query is detoriating with a steep curve. How can this problem be solved ? Thanks and Regards Sameer Maggon
В списке pgsql-sql по дате отправления: