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 example
should
I have a index on all fields
-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 Neilneil.tompk...@googlemail.com
neil.tompk...@googlemail.com wrote:
Hi,
Can anyone help and offer some advice with regards MySQL indexes.
Basically
we have
Neilneil.tompkins@**
googlemail.com neil.tompk...@googlemail.com
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 the obviously
primary
keys. We then have some queries
...@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 the obviously
primary
keys. We then have some queries using JOIN statements that run slowly
than
we wanted. How many indexes
/5.5/en/fulltext-natural-language.html
On Thu, Oct 6, 2011 at 10:59 AM, Tompkins Neilneil.tompkins@**
googlemail.com neil.tompk...@googlemail.com
neil.tompk...@googlemail.com wrote:
Hi,
Can anyone help and offer some advice with regards MySQL indexes.
Basically
we have a number
/doc/refman/5.5/en/fulltext-natural-language.html
On Thu, Oct 6, 2011 at 10:59 AM, Tompkins Neilneil.tompkins@**
googlemail.com neil.tompk...@googlemail.com
neil.tompk...@googlemail.com wrote:
Hi,
Can anyone help and offer some advice with regards MySQL indexes.
Basically
we
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 the obviously
primary
keys. We then have some queries using JOIN statements that run
slowly
than
we wanted. How many indexes are recommended per
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
neil.tompk...@googlemail.com wrote:
Hi,
Can anyone help and offer some advice with regards MySQL indexes. Basically
we have a number
, 2011 at 10:59 AM, Tompkins Neilneil.tompkins@**
googlemail.com neil.tompk...@googlemail.com
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 the
obviously
-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 by first name, last name
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
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
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
,
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
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 example should
I have a index
...@googlemail.com
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 the obviously
primary
keys. We then have some queries using JOIN statements that run slowly
than
we
...@googlemail.com
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 the obviously
primary
keys. We then have some queries using JOIN statements that run slowly
than
we wanted
17 matches
Mail list logo