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
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
2 matches
Mail list logo