← Back to team overview

maria-discuss team mailing list archive

Re: doubt about index


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

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@xxxxxxxxx

    The ignore index hint.  That will ignore the index

Attachment: signature.asc
Description: OpenPGP digital signature

Follow ups