Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.20 » View Incident Report |
Serious |
Reported By: Ron Clayton Reported On: 5/11/2005 For: Version 4.19 Build 1 |
Query Results: ================================================================================ SQL statement ================================================================================ select * from siteinfo where ( (SITECITY = 'RIO LINDA') AND (SITEZIP = 95673) ) Tables Involved --------------- siteinfo (siteinfo) table opened shared, has 431222 rows Result Set Generation --------------------- Result set will be live Result set will consist of one or more rows Result set will be ordered by the primary index for the table siteinfo Non-Optimized WHERE Clause Execution ------------------------------------ The expression: SITECITY = 'RIO LINDA' AND SITEZIP = 95673 has been rewritten and is OPTIMIZED, costs 186287904 bytes, and will be applied to the siteinfo table (siteinfo) before any joins ================================================================================ Execution time: 0.043 sec ================================================================================ ================================================================================ SQL statement ================================================================================ select * from siteinfo where ( (SITECITY = 'SACRAMENTO') AND (SITEZIP = 95814) ) Tables Involved --------------- siteinfo (siteinfo) table opened shared, has 431222 rows Result Set Generation --------------------- Result set will be live Result set will consist of one or more rows Result set will be ordered by the primary index for the table siteinfo Non-Optimized WHERE Clause Execution ------------------------------------ The expression: SITECITY = 'SACRAMENTO' AND SITEZIP = 95814 has been rewritten and is PARTIALLY-OPTIMIZED, costs 2076228 bytes, and will be applied to the siteinfo table (info) before any joins ================================================================================ Execution time: 0.812 sec ================================================================================ ================================================================================ SQL statement ================================================================================ select * from siteinfo where ( (SITECITY = 'RIO LINDA') AND (SITEZIP = 95673) ) OR ( (SITECITY = 'SACRAMENTO') AND (SITEZIP = 95814) ) Tables Involved --------------- siteinfo (siteinfo) table opened shared, has 431222 rows Result Set Generation --------------------- Result set will be live Result set will consist of one or more rows Result set will be ordered by the primary index for the table siteinfo Non-Optimized WHERE Clause Execution ------------------------------------ The expression: SITECITY = 'RIO LINDA' AND SITEZIP = 95673 OR SITECITY = 'SACRAMENTO' AND SITEZIP = 95814 is UN-OPTIMIZED, costs 186287904 bytes, and will be applied to the siteinfo table (siteinfo) before any joins ================================================================================ Execution time: 1.64 sec ================================================================================
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 |