470,815 Members | 1,320 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Both full text and normal index to the same field

Hi

I had a normal KEY INDEX on one VARCHAR field
I then added a FULLTEXT KEY to the same field.

I wonder if I should now remove the normal KEY INDEX
as obsolete or leave it? Can I expect the FULLTEXT index
to behave just like normal KEY index (if using without
the match operation)? Would there be some performance
difference in this respect?

thanks,
Lance
Jul 20 '05 #1
0 931

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by karolina | last post: by
reply views Thread by Quinton | last post: by
reply views Thread by Robert Oschler | last post: by
1 post views Thread by JT | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.