← Back to team overview

maria-discuss team mailing list archive

Re: doubt about index

 

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@xxxxxxxxxxxxx> 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@xxxxxxxxx
>> <mailto:greenlion@xxxxxxxxx>>:
>> 
>>    The ignore index hint.  That will ignore the index
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp


References