Re: Index

El viernes, 19 de julio de 2019, 22:57:50 (UTC-5), The Natural Philosopher escribió:
> On 19/07/2019 22:25, mmmmvh_at_gmail.com wrote:
> > Good evening.
> >
> > This query
> >
> > select * from table where name = "Erick" and month = "10"
> >
> > Is it faster if I have an index to name and another index to month?
> > Is it more convenient to have a single index (name, month)?
> >
> > Thanks.
> >
> easy answer.
>
> Try each combination.
>
> Reboot mysqld between changes to ensure no cached queries.
>
> My limited experience is that indices always improve searches on 'where'
> clauses, and the downside is speed of insertion, but many applications
> are 'write once/read many', so thats a optimal tradeoff.
>
>
>
> --
> The New Left are the people they warned you about.

Thank you very much everyone for your contributions. Received on Mon Jul 22 2019 - 16:43:43 CEST