MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Partial key
Posted by: Felix Geerinckx
Date: June 17, 2005 01:28AM

noudshoorn wrote:

> Why do I want to use a specific index. Because I want the rows that are showed always in the order
> of name, departuredate and departure time when someone searches for informaion on name, no
> matter how many rows are in the table. Therfore I made the index.

But the order in which records are returned does not depend on whether an index is used or not. If you want your records returned in a particular order, use an ORDER BY clause, in this particular case ORDER BY name, departuredate, departuretime

--
felix
Please use BBCode to format your messages in this forum.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Partial key
3582
noudshoorn
June 11, 2005 12:03PM
Re: Partial key
1831
Boris Burtin
June 14, 2005 10:42AM
Re: Partial key
1958
noudshoorn
June 14, 2005 02:16PM
Re: Partial key
1698
Felix Geerinckx
June 15, 2005 02:21AM
Re: Partial key
1700
noudshoorn
June 15, 2005 05:16AM
Re: Partial key
1852
Felix Geerinckx
June 15, 2005 06:24AM
Re: Partial key
5054
noudshoorn
June 15, 2005 12:06PM
Re: Partial key
1758
Felix Geerinckx
June 16, 2005 05:07AM
Re: Partial key
1729
noudshoorn
June 16, 2005 07:57AM
Re: Partial key
1729
Felix Geerinckx
June 16, 2005 08:30AM
Re: Partial key
1785
noudshoorn
June 16, 2005 08:50AM
Re: Partial key
1636
Felix Geerinckx
June 16, 2005 10:21AM
Re: Partial key
2740
Ulf Wendel
June 16, 2005 03:00PM
Re: Partial key
1729
noudshoorn
June 17, 2005 12:00AM
Re: Partial key
1650
Felix Geerinckx
June 17, 2005 01:28AM
Re: Partial key
1633
noudshoorn
June 20, 2005 01:21AM
Re: Partial key
1825
Ulf Wendel
June 20, 2005 06:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.