On Thu, Sep 11, 2008 at 10:08 AM, Marcus Engene <mengpg2(at)engene(dot)se> wrote:
> select
> objectid
> from
> apa
> where
> created_at > now() - interval '1 day'
> order by
> objectid desc;
>
> In this select, it would have been nice to dodge the full table scan without
> adding an index to created_at. Is this possible somehow?
Not really. It's a choice of one or the other.