>My question is: can these indexes be used for SQL-select? Say, I open the tables with the right indexes (IDX) before running my select statements.
Yes they work, you need to create/update/open them manually, but they will work
(When I say update I mean reindex before using it, for it might be out of date)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges