Hi, The following query
SELECT START_DATE_IDX, COUNT(*) FROM RUNINFO_HISTORY WHERE START_DATE_IDX>=1005 group by START_DATE_IDX runs for about 200s on Postgres, but 13s on MS SQL Server, on the same machine. The searched column is indexed. By reading the "explain" you can tell that the index is being used. Any idea? Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
