Re: [PERFORM] Why does not perform index combination

2006-02-16 Thread Adnan DURSUN
>From: Tom Lane >Date: 02/16/06 19:29:21 >To: Adnan DURSUN >Cc: pgsql-performance@postgresql.org >Subject: Re: [PERFORM] Why does not perform index combination   >"Adnan DURSUN" <[EMAIL PROTECTED]> writes: >>   I have query for a report. Explain anal

Re: [PERFORM] Why does not perform index combination

2006-02-16 Thread Tom Lane
"Adnan DURSUN" <[EMAIL PROTECTED]> writes: > I have query for a report. Explain analyze result is below. The = > execution plan tells that it would use "t_koltuk_islem_pkey" index on = > table "t_koltuk_islem" to scan. However, there is another index on table = > "t_koltuk_islem" on column "islem

[PERFORM] Why does not perform index combination

2006-02-16 Thread Adnan DURSUN
HI ALL,     I have query for a report. Explain analyze result is below. The execution plan tells that it would use "t_koltuk_islem_pkey" index on table "t_koltuk_islem" to scan. However, there is another index on table "t_koltuk_islem" on column "islem_tarihi" that can be combined on plan. W