469,950 Members | 1,420 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

Full text index before or after non-clustered index

Folks,

In mySQL should any required non-clusterd indexes be built before or
after a full-text index? Either on the same column or different
columns...

Would appreciate any view/experiences that you may have on this
issue.

Cheers & thanks,
Al.
The mySQL newbie

Dec 20 '06 #1
1 3527
al*****@altavista.com wrote:
Folks,

In mySQL should any required non-clusterd indexes be built before or
after a full-text index? Either on the same column or different
columns...

Would appreciate any view/experiences that you may have on this
issue.

Cheers & thanks,
Al.
The mySQL newbie
The order of creating indexes is really quite irrelevent.

--
Michael Austin.
Database Consultant
Dec 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by CJM | last post: by
6 posts views Thread by John Dalberg | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.