PostgreSQL'de başarım

• tdmsoft=# CREATE INDEX info_tarih_idx ON info USING btree (tarih) WHERE tarih > '2004-01-01'; CREATE INDEX

• test=# EXPLAIN SELECT tarih FROM info WHERE tarih > '2004-01-01'; Index Scan using info_tarih_idx on info (cost=0.00..1175320.50 rows=1000 width=4) Index Cond: (tarih > '2004-01-01'::date)

Notes: