* [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
>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 2:59 AM
Subject: Using indexes on mysql.
> hi all,
>
> this will sound very stupid, but i guess it will be helpful to mysql
newbies
> like me.
>
> Here's my Qu : What's the use of using indexes in mysql ?
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
hi all,
this will sound very stupid, but i guess it will be helpful to mysql newbies
like me.
Here's my Qu : What's the use of using indexes in mysql ? Why do we create
an index anyway ?
thank you,
regards
ally
-
Before po