Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 1.02 » View Incident Report |
Minor |
Reported By: Harry de Boer Reported On: 4/19/2007 For: Version 1.02 Build 1 |
select * from test where veld1 in (200,2000) ================================================================================ SQL Query (Executed by ElevateDB 1.02 Build 1) Note: The SQL shown here is generated by ElevateDB and may not be exactly the same as the SQL that was originally entered. However, none of the differences alter the execution results in any way. ================================================================================ SELECT ALL "test"."veld1" AS "veld1", "test"."veld2" AS "veld2", "test"."veld3" AS "veld3" FROM "test" WHERE "veld1" IN (200, 2000) Source Tables ------------- test: 1000002 rows Result Set ---------- The result set was static The result set consisted of zero or more rows Filtering --------- The following filter condition was applied to the test table: "veld1" IN (200, 2000) [Row scan: 1000002 rows, 56000112 bytes estimated cost] ================================================================================ 2 row(s) returned in 2,516 secs ================================================================================ select * from test where veld1 = 200 or veld1 = 2000 ================================================================================ SQL Query (Executed by ElevateDB 1.02 Build 1) Note: The SQL shown here is generated by ElevateDB and may not be exactly the same as the SQL that was originally entered. However, none of the differences alter the execution results in any way. ================================================================================ SELECT ALL "test"."veld1" AS "veld1", "test"."veld2" AS "veld2", "test"."veld3" AS "veld3" FROM "test" WHERE "veld1" = 200 OR "veld1" = 2000 Source Tables ------------- test: 1000002 rows Result Set ---------- The result set was static The result set consisted of zero or more rows Filtering --------- The following filter condition was applied to the test table: "veld1" = 200 OR "veld1" = 2000 [Index scan: 1 keys, 4096 bytes estimated cost] ================================================================================ 2 row(s) returned in 0 secs ================================================================================
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |