[HACKERS] [Fwd: Re: [GENERAL] Unisersal B-Tree]

2001-05-04 Thread Justin Clift
Hi all, Not sure if this is useful, but it might be good to file and reference somewhere. Regards and best wishes, Justin Clift Original Message Subject: Re: [GENERAL] Unisersal B-Tree Date: Mon, 30 Apr 2001 17:59:49 +0200 From: Jörg Schulz [EMAIL PROTECTED] Organization:

Re: [HACKERS] [Fwd: Re: [GENERAL] Unisersal B-Tree]

2001-05-04 Thread Tom Lane
... Think of a query like this: select a,b,c from table where ( amin_a and amax_a ) and ( bmin_b and bmax_b ) In a conventional implementation you have two indexes on attributes a and b. But to run this query the database engine profits only from one index. It has to run through all the