MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Creating an index to include ORDER BY
Posted by: Yogesh Salvi
Date: December 13, 2006 05:02AM

Hello,

I would suggest you to create complosite index like this :-

index on (DateColumn,ThePrimaryKeyColumn,NumberColumn)

This index should be used my mysql even if your query is not having "NumberColumn" in it.

Regards,
Yogesh Salvi

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


Subject
Views
Written By
Posted
Creating an index to include ORDER BY
3209
Angus
November 02, 2006 08:28AM
Re: Creating an index to include ORDER BY
1986
KimSeong Loh
November 02, 2006 05:31PM
Re: Creating an index to include ORDER BY
2064
Angus
November 03, 2006 09:24AM
Re: Creating an index to include ORDER BY
2066
Yogesh Salvi
December 13, 2006 05:02AM


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.