Forum OpenACS Q&A: Response to "vacuum analyse" messing up the row ordering?

Collapse
Posted by Ola Hansson on
I see...Thanks!

Will the query be much faster if the "order by" is made on the indexed primary key (move_id) in comparison to having it on move_number which isn't indexed? (I expect holding quite a number of rows in this table, down the road).