Re: MySQL Indexes

2011-10-07 Thread mos
At 01:58 PM 10/7/2011, you wrote: Do you have any good documentation with regards creating indexes. Also information for explain statement and what would be the desired result of the explain statement? This might help: http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html http://www.site

Re: FW: MySQL Indexes

2011-10-07 Thread Brandon Phelps
That cleared it up for me. Thanks! On 10/07/2011 03:06 PM, Jerry Schwartz wrote: -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Friday, October 07, 2011 12:21 PM To: mysql@lists.mysql.com Subject: Re: MySQL Indexes but could this not be called a bug

FW: MySQL Indexes

2011-10-07 Thread Jerry Schwartz
>-Original Message- >From: Reindl Harald [mailto:h.rei...@thelounge.net] >Sent: Friday, October 07, 2011 12:21 PM >To: mysql@lists.mysql.com >Subject: Re: MySQL Indexes > >but could this not be called a bug? > [JS] No. Think of two telephone books: one is sorted

Re: MySQL Indexes

2011-10-07 Thread Michael Dykman
> >>>>>>> index > >>>>>>> on individual column ? > >>>>>>> > >>>>>>> > >>>>>>> On 6 Oct 2011, at 17:28, Michael Dykman wrote: > >>>>>>> > >>>>>>

Re: MySQL Indexes

2011-10-07 Thread Neil Tompkins
> in the that database (the test itself being expensive as infix finding is >> iterative). Perhaps you should consider this approach instead: >> http://dev.mysql.com/doc/refman/5.5/en/fulltext-natural-language.html >> >> On Thu, Oct 6, 2011 at 10:59 AM, Tompkins Neil &

Re: MySQL Indexes

2011-10-07 Thread Neil Tompkins
t; results. >>>>>>> >>>>>>> The second query is founded on this phrase: "Like '%Red%' " and no >> index >>>>>>> will help you there. This is an anti-pattern, I am afraid. The only >>>>>&g

Re: MySQL Indexes

2011-10-07 Thread Michael Dykman
gt;> The second query is founded on this phrase: "Like '%Red%' " and no > index > >>>>> will help you there. This is an anti-pattern, I am afraid. The only > >>>>> way > >>>>> your database can satisfy that expression is to

Re: MySQL Indexes

2011-10-07 Thread Reindl Harald
> way >>>>> your database can satisfy that expression is to test each and every >>>>> record >>>>> in the that database (the test itself being expensive as infix finding >>>>> is >>>>> iterative). Perhaps you should consider this app

Re: MySQL Indexes

2011-10-07 Thread Michael Dykman
e). Perhaps you should consider this approach instead: >>> <http://dev.mysql.com/doc/refman/5.5/en/fulltext-natural-language.html> >>> http://dev.mysql.com/doc/refman/5.5/en/fulltext-natural-language.html >>> >>> On Thu, Oct 6, 2011 at 10:59 AM, Tompkins Neil >>>

Re: MySQL Indexes

2011-10-07 Thread Michael Dykman
t;>> your database can satisfy that expression is to test each and every >>>> record >>>> in the that database (the test itself being expensive as infix finding >>>> is >>>> iterative). Perhaps you should consider this approach instead: >&g

Re: MySQL Indexes

2011-10-07 Thread Brandon Phelps
dev.mysql.com/doc/refman/5.5/en/fulltext-natural-language.html> http://dev.mysql.com/doc/refman/5.5/en/fulltext-natural-language.html On Thu, Oct 6, 2011 at 10:59 AM, Tompkins Neil< neil.tompk...@googlemail.com> wrote: Hi, Can anyone help and offer some advice with regards MySQL indexes. Basically

Re: MySQL Indexes

2011-10-07 Thread Tompkins Neil
ltext-natural-language.html >> >> On Thu, Oct 6, 2011 at 10:59 AM, Tompkins Neil >> < >> neil.tompk...@googlemail.com> wrote: >> >>> Hi, >>> >>> Can anyone help and offer some advice with regards MySQL indexes. >>> Basically >

Re: MySQL Indexes

2011-10-06 Thread Nuno Tavares
; <http://dev.mysql.com/doc/refman/5.5/en/fulltext-natural-language.html> >> http://dev.mysql.com/doc/refman/5.5/en/fulltext-natural-language.html >> >> On Thu, Oct 6, 2011 at 10:59 AM, Tompkins Neil >> < >> neil.tompk...@googlemail.com> wrote: >> >>

Re: MySQL Indexes

2011-10-06 Thread Michael Dykman
uage.html > > On Thu, Oct 6, 2011 at 10:59 AM, Tompkins Neil < > neil.tompk...@googlemail.com> wrote: > >> Hi, >> >> Can anyone help and offer some advice with regards MySQL indexes. >> Basically >> we have a number of different tables all of which have t

Re: MySQL Indexes

2011-10-06 Thread Neil Tompkins
: > Hi, > > Can anyone help and offer some advice with regards MySQL indexes. Basically > we have a number of different tables all of which have the obviously primary > keys. We then have some queries using JOIN statements that run slowly than > we wanted. How many indexes are rec

Re: MySQL Indexes

2011-10-06 Thread Michael Dykman
> > Can anyone help and offer some advice with regards MySQL indexes. > Basically > we have a number of different tables all of which have the obviously > primary > keys. We then have some queries using JOIN statements that run slowly than > we wanted. How many indexes are r

MySQL Indexes

2011-10-06 Thread Tompkins Neil
Hi, Can anyone help and offer some advice with regards MySQL indexes. Basically we have a number of different tables all of which have the obviously primary keys. We then have some queries using JOIN statements that run slowly than we wanted. How many indexes are recommended per table ? For