partial index + select query performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: partial index + select query performance
From: "petchimuthu lingam" <spmlingam@xxxxxxxxx>
Date: Thu, 13 Mar 2008 12:51:54 +0530

I have created partial index on a field with conditions, if field _a > 200 and field_a < 300.

I using the select query with condition as field_a in ( 100, 250, 289, ),

Will it use the index.

--
With Best Regards,
Petchimuthulingam S

Follow-Ups:
- Re: partial index + select query performance
  - From: A. Kretschmer

Prev by Date: Re: Repeated execution of identical subqueries
Next by Date: Re: partial index + select query performance
Previous by thread: Repeated execution of identical subqueries
Next by thread: Re: partial index + select query performance
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux