indices
Sandeep Joshi <sjoshi@zambeel.com>
From: Sandeep Joshi <sjoshi@Zambeel.com>
To:
Cc: pgsql-general@postgresql.org
Date: 2000-11-30T01:31:16Z
Lists: pgsql-general
Hi,
I had learned in theory that Hash indices are used for "=" and
B-tree for "<" ,">".
explain command doesn't tell us which index it is using. Hash or
Btree?
Also,
should a following query
"id < 1243" invoke a index ? (assuming there is an index on id).
I have seen Postgres using Seq scan. Is sequential scan done afer
getting the first
page for "1243"?
Sandeep