reHi Adam,
If it is indexed then you are starting at the first match, not at the top.
The only way it would start at the top is if you were doing a full table
scan. My example was to show that once the field is indexed, you can fetch
ASC or DESC at the same speed.
Cal
http://www.calevans.com
-----Original Message-----
From: Adam C Buggia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 1:42 PM
To: Cal Evans
Cc: [EMAIL PROTECTED]
Subject: RE: indexing
> Why do you need to build your index in descending order?
I am the dba for a track and field results web site, when people look for
results they are most likely going to want results from a more recent meet
(rather than older meets).
there is a table result and a table meet where a column in result is
"meet_hnd." (there maybe hundreds of results per meet) so I have indexed
the result table on meet_hnd. This sped things up dramatically. Now, the
I see it, though we are indexed on meet_hnd, when searching for results
mysql is starting at the first meet_hnd though we are most likely wanting
to retrieve the last meet_hnd. If this were indexed in reverse order than
the first meet_hnd would most likely be the one we are looking for.
>
> Cal
> http://www.calevans.com
>
>
> -----Original Message-----
> From: Adam C Buggia [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 22, 2001 12:42 PM
> To: [EMAIL PROTECTED]
> Subject: indexing
>
>
>
>
> When is there going to be the ability to index in descending order?
>
>
>
> --------------------
> Adam C Buggia
>
> DirectAthletics Inc.
> W: 978 927 7188
> C: 781 608 5952
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
