Hi, I've got a database table with a datetime column "deleted_at". I'll be running lots of queries against the table but they'll all be of the nature "deleted_at IS NULL" and "deleted_at IS NOT NULL".
What's the best index to place on this column? I assume if I add just a straight index then it'll index all of the values that go into it.
pgsql-novice by date
|Next:||From: Gavin Flower||Date: 2012-08-26 09:35:29|
|Subject: Re: best index for timestamp field null and not null queries|
|Previous:||From: Prima Chairunnanda||Date: 2012-08-25 19:33:11|
|Subject: Re: Hot Standby Lagging Behind|