We have converted an app from paradox to interbase.
So the tables are the same, the indexes are the same, even the data
is the same dataset - just datapumped from paradox to interbase.

Using TUTI on the paradox db, the query

SELECT sum(routing.subtotal) as SumAgentTotal

FROM hub, waybill, routing, agent

WHERE costcntr = 2
and routing.agent = agent.agent
and agent.ownresource = FALSE

and waybill.orighub = hub.hub
and waybill.waybill = routing.waybill

and invdate >= '08/01/2001'
and invdate <= '08/31/2001'

takes 3 seconds

Using IBConsole on the interbase db the same query (on the same PC)
takes 50 seconds - the only diff in the query using 0 instead of FALSE

Using D5 - IB6.

Any ideas ?