Should it be worked around in hacky way or should someone actually invest in fixing the terribly broken optimizer? Sent from my iPhone
On Jun 26, 2015, at 1:40 AM, Reindl Harald <h.reindl@thelounge.net> wrote:
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
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp