Warm tip: This article is reproduced from stackoverflow.com, please click
limit netezza nzsql sql

Max parameter that can pass IN clause in Netezza

发布于 2020-03-27 10:15:36

In Netezza, One can specify an IN clause, like this: (just like sql)

 SELECT * FROM user WHERE id IN (1000, 1001, 1002)

Does anyone know what's the maximum number of parameters you can pass into IN?

I know Oracle allows up to 1,000 IN list values in a SQL statement.

Questioner
Aditya Dhanraj
Viewed
134
分享
Zaynul Abadin Tuhin 2019-07-03 21:52

The limit would be the maximum physical length of a SQL statement allowed by Netezza.

If the number of IN members exceeds a threshold specified by the INLIST_THRESHOLD setting, the system will write the list to disk for use in the query. If the number of members is at or below the threshold, the in list values will be compiled into the query and pushed to the FGA for disk-level filtering (faster). You can control the threshold setting forum discussion

Related issues

1
Query is possibly slow?
2
Simple Sql Role query issue
3
Group by query with rollup
4
How to include a PHP variable inside a MySQL statement
5
Getting empty rows from "SELECT ALL" query in PostgreSQL
6
MySQL pivot table using java
7
Implement smart search by text field in database
8
How to speed up count(distinct) with Between clause in MySQL
9
how to perform sql query MIN/MAX FILTER
10
Dynamic pivot in oracle sql