| From: | Bjørn T Johansen <btj(at)havleik(dot)no> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Indexes? |
| Date: | 2004-12-02 06:11:29 |
| Message-ID: | 41AEB211.2050202@havleik.no |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a table where I need to use "..where curdate between fromDate and toDate".
Is it best to have two indexes, one for FromDate and one for toDate or just one index for
both the fields?
Regards,
BTJ
--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen
btj(at)havleik(dot)no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2004-12-02 06:59:07 | Re: [HACKERS] Adding Reply-To: <listname> to Lists configuration ... |
| Previous Message | Jan Wieck | 2004-12-02 04:10:01 | Re: Upcoming Changes to News Server ... |