Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.21 » View Incident Report |
Minor |
Reported By: Tiago Ameller Reported On: 5/24/2005 For: Version 4.20 Build 2 |
This query is optimized, very fast: SELECT Articulo, Ejercicio, Concepto, AlmacenOri, AlmacenDes,Modo, SUM(Unidades1) AS Unidades1, SUM(Unidades2) AS Unidades2, SUM(Importe1) AS Importe1, SUM(Importe2) AS Importe2 FROM "K:\SFCLIE\01027\DATA\EM000001\SFEAR041" WHERE Articulo = '35093' AND Concepto IN (000 , 001 , 002 , 003 , 013 , 014 , 015 , 016) AND Ejercicio = 2005 -- AND True GROUP BY Ejercicio While if you uncomment the AND TRUE, query is not optimized and 100 times slower
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 |