Am 26.06.2015 um 10:09 schrieb Roberto Spadim:
the problem is, i don't know whats the index of order by without knowing the sql, the 'create' table and the optimizer choise/options but i want that optimizer avoid the order by index with a optimizer_switch configuration or a sql hint i don't know if it's possible, i don't want to add a FROM table IGNORE INDEX (some index), i want something like ORDER BY IGNORE INDEXES some_columns
but you won't get that because you *have to know* your tables and queries - "IGNORE INDEXES some_columns" would be by all respect pure stupidity because *everybody* excepts here to list index names P.S.: there is not need to "reply all" on a mailing-list and so sent duplicates to all the people you list additionally as CC
2015-06-26 4:42 GMT-03:00 Justin Swanhart <greenlion@gmail.com <mailto:greenlion@gmail.com>>:
The ignore index hint. That will ignore the index