Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.16 » View Incident Report |
Minor |
Reported By: Helmut Schiefer Reported On: 12/8/2004 For: Version 4.15 Build 1 |
/* Table1 from DBBench from Ole */ CREATE TABLE IF NOT EXISTS "Table1" ( "T1_Key" INTEGER, "T1_SFld1" CHAR(30), "T1_SFld2" CHAR(30), "T1_Fld1" CHAR(10), "T1_Fld2" CHAR(10), PRIMARY KEY ("T1_Key") COMPRESS NONE LOCALE CODE 0 USER MAJOR VERSION 1 ); CREATE INDEX IF NOT EXISTS "ix_T1_SFld1" ON "Table1" ("T1_SFld1"); Slow Query: (un-optimized) ============ SELECT * FROM TABLE1 WHERE(T1_SFLD1 like 'Smith') Fast Query: ============ SELECT * FROM TABLE1 WHERE(T1_SFLD1 = 'Smith') Slow Query: is PARTIALLY-OPTIMIZED, costs 0 bytes ============ SELECT * FROM TABLE1 WHERE T1_KEY BETWEEN 3800 AND 4000 AND (T1_SFLD1 = 'Smith') ============ is PARTIALLY-OPTIMIZED, costs 0 bytes Fast Query: ============ SELECT * FROM TABLE1 WHERE T1_KEY BETWEEN 3800 AND 4000 AND (T1_SFLD1 like 'Smith') ============ is PARTIALLY-OPTIMIZED, costs 500000 bytes
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |