Re: Reducing planning time of large IN queries on primary key / unique columns

2022-08-11 Thread Souvik Bhattacherjee
Hi hackers, (Sorry about the re-post. Another attempt at fixing the formatting) At ServiceNow, we frequently encounter queries with very large IN lists where the number of elements in the IN list range from a few hundred to several thousand. For a significant fraction of the queries, the IN claus

Re: Reducing planning time of large IN queries on primary key / unique columns

2022-08-11 Thread Souvik Bhattacherjee
(Re-posting with better formatting) Hi hackers, At ServiceNow, we frequently encounter queries with very large IN lists where the number of elements in the IN list range from a few hundred to several thousand. For a significant fraction of the queries, the IN clauses are constructed on primary k

Reducing planning time of large IN queries on primary key / unique columns

2022-08-11 Thread Souvik Bhattacherjee
Hi hackers, At ServiceNow, we frequently encounter queries with very large IN lists where the number of elements in the IN list range from a few hundred to several thousand. For a significant fraction of the queries, the IN clauses are constructed on primary key columns. While planning these queri