Hi,
Could u just tell me, why do my Access queries run at least 2 times faster than PG queries and 1.5 times faster than MS-SQL. The query involves one master table containing 10000 records, left - joined for getting Transactional sums from records in other tables... Purchases, Sales, PurReturns, SalesReturns, OtherIssues.
It takes 60-75 seconds in access, 100-120 seconds in SQL Server and 150 seconds in PG
Secondly, is it possible to have an index like :
create index in_a on a.id where a.id>5000
Thanx
Kapil