Skip to content

Instantly share code, notes, and snippets.

@arunthampi

arunthampi/desc_order_index.sql

Created December 6, 2011 06:25
Show Gist options
  • Save arunthampi/1437033 to your computer and use it in GitHub Desktop.
Save arunthampi/1437033 to your computer and use it in GitHub Desktop.
Download ZIP
Descending order indexes leads to 10x improvement in response time
Raw
desc_order_index.sql
CREATE INDEX desc_created_citems_idx on channel_items(created_at DESC NULLS LAST);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment