Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

suggesting add index on row_order #95

Closed
jhjwind opened this issue Mar 31, 2015 · 1 comment
Closed

suggesting add index on row_order #95

jhjwind opened this issue Mar 31, 2015 · 1 comment

Comments

@jhjwind
Copy link

jhjwind commented Mar 31, 2015

we use rank model on our markets table. We didn't have an index on the row_order and ended up with lots of seq scan on the row_roder column. I suggest adding index on the row_order column. It would be great if you can put it in the readme.

 SELECT "markets".* FROM "markets"   ORDER BY "markets"."row_order" ASC                                                                                                                                     
@brendon
Copy link
Owner

brendon commented Jun 4, 2024

Happy to accept a PR about this for the Readme if it hasn't already been done in the meantime. Closing for now.

@brendon brendon closed this as completed Jun 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants