On Wed, Apr 7, 2010 at 1:20 PM, <Sherry(dot)CTR(dot)Zhu(at)faa(dot)gov> wrote:
> Thanks for trying and opening your mind.
> If you want to know how Oracle addressed this issue, here it is: index
> on two columns. I remember that they told me in the training postgres has
> no this kind of index, can someone clarify?
lies. postgresql allows you indices on multiple columns. What it does not
have, is index on multiple tables.
In response to
pgsql-performance by date
|Next:||From: Sherry.CTR.Zhu||Date: 2010-04-07 13:08:36|
|Subject: Re: LIMIT causes planner to do Index Scan using a less optimal
|Previous:||From: Sabin Coanda||Date: 2010-04-07 12:47:54|
|Subject: How check execution plan of a function|