Re: [GENERAL] Tuning queries and distinct behaviour

2001-01-18 Thread Stephan Szabo
On Thu, 18 Jan 2001, Gordan Bobic wrote: > Is there a way to tune queries? > > I'm doing queries that join around 5-6 tables. All join fields are indexed > either in hash (where tables are small enough and join is done on "="), or > btree (big tables, not joined on "="). The tables have between

[GENERAL] Tuning queries and distinct behaviour

2001-01-18 Thread Gordan Bobic
Is there a way to tune queries? I'm doing queries that join around 5-6 tables. All join fields are indexed either in hash (where tables are small enough and join is done on "="), or btree (big tables, not joined on "="). The tables have between several hundred and several tens of millions of reco