SQL IN子句1000项目限制 [英] SQL IN Clause 1000 item limit

问题描述

是否可以在SQL IN子句中放置1000多个项目?我们一直在遇到无法处理Oracle数据库的问题.

It is possible to put more than 1000 items in the SQL IN clause? We have been getting issues with our Oracle database not being able to handle it.

如果是，我们如何在SQL IN子句中放置1000多个项目?

IF yes, how do we put more than 1000 items in the SQL IN clause?

如果没有，我还能怎么办?

IF not, what else can I do?

推荐答案

您应将IN子句转换为INNER JOIN子句.

You should transform the IN clauses to INNER JOIN clauses.

您可以转换这样的查询

SELECT  foo   
FROM    bar   
WHERE bar.stuff IN  
       (SELECT  stuff FROM asdf)

在与其他查询类似的查询中.

in a query like this other one.

SELECT  b.foo 
FROM    ( 
        SELECT  DISTINCT stuff 
        FROM    asdf ) a 
JOIN    bar b 
ON      b.stuff = a.stuff

您还将获得很多表现

这篇关于SQL IN子句1000项目限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！