* [EMAIL PROTECTED]
> 1 reason and 1 reason only. To speed up queries.
I would say there are three reasons to use indexes:
1) To speed up queries
2) To create constraints
3) To maintain a sort order
If you have an order table and an order_line table, it is important that
line no 1 only exists
ally,
Thursday, June 13, 2002, 10:59:00 AM, you wrote:
a> this will sound very stupid, but i guess it will be helpful to mysql newbies
a> like me.
a> Here's my Qu : What's the use of using indexes in mysql ?
Indexes are used for query optimization. Rows in the table are
unodered and if there ar
1 reason and 1 reason only. To speed up queries. The flip side of that is
if you have an index that is not being used by a query somewhere, get rid of
it.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "ally" <[EMAIL PROTECTED]>
To: <[EMAIL PROTE
Consider the usefulness of a book's index. Instead of
scanning several hundred pages of text to find a particular
word you look at an alphabetical list that tells you the
locations in which the word is found. It's a lot faster, yes?
> Here's my Qu : What's the use of using indexes in mysql ? Why
