[web2py] Re: Indexes

2015-11-12 Thread p a
In case your question was more basic: you define indices, then just issue sql commands normally, and the database will benefit from the existence of the indices (many queries will run faster if the indices are there, but no modification is needed of the query itself). BTW, I didn't know you cou

[web2py] Re: Indexes

2015-11-12 Thread Niphlod
It's backend's job to know if it's "better" to use the index or to proceed as normal. It's normally referred as "query optimizer stage". In SOME backends you can issue rather specific sql "hints" to "optimize yourself" (if you think you're smarter than your backend) the query, but being that sp