NIM031527 for No Product Found

漏洞 ID 编号	NIM031527
已提交	January 23, 2008
上次修改时间	April 28, 2025
适用范围	No Product Found
找到的版本	9.2
状态	Known Limit

附加信息

No Public Explanation

解决办法

Modify the where clause for your oracle case to use nested queries or joins...Joins would be the fastest - "or" and "in" clauses are normally much slower.Examples:select * from user.Parcels where (PARCEL_ID in (1...1000) orPARCEL_ID in (1001...2000) )=================(select ... from ... where PARCEL_ID in (1, 2, ... 1000) )UNION(select ... from ... where PARCEL_ID in (1001, 1002, ... 2000))...UNION(select ... from ... where PARCEL_ID in (N, N+1, ... M)=================You can use ArcObjects (IDatabaseConnectionInfo2.ConnectionDBMS Property) to determine the type of GDB connected to if needed.