Skip to content

Instantly share code, notes, and snippets.

@zolzaya

zolzaya/add_index.js

Created October 8, 2011 07:04
Show Gist options
  • Save zolzaya/1271974 to your computer and use it in GitHub Desktop.
Save zolzaya/1271974 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
add_index.js
In SQL:
CREATE INDEX uindex ON users(username, created_at);
In MongoDB:
db.users.ensureIndex({created_at: 1, username: 1})
db.users.getIndexes()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment