Using multiple IN statements in WHERE clause results in EOF on communication channel
We have an application that is running a count statement against a table to determine the number of records we will be retrieving back from the table prior to loading the data.
We have two environments that are running the same code:
-
Environment A - Linux based Oracle 10.2.0.3 implementation
-
Environment B - Solaris Based Oracle 10.2.0.3 implementation
The table we are running a count against has multiple rows per ID (about 2.5 million rows total in the table), so our count query looks like this:
Select count(distinct SCID) from myTable a
where a.SCID in (2304, 2305, 3589, 7649, 8972...) -- this can have up to 999 values in it
0