List:General Discussion« Previous MessageNext Message »
From:Robert DiFalco Date:October 17 2006 3:28pm
Subject:Prefix Indices
View as plain text  
I have some long VARCHAR fields that a user will sometimes sort on. Does
a prefix index in any way help with sorting or just for lookups? Will it
speed up a filesort? I couldn't find this information in "How MySQL uses
indices".
 
R.
Thread
• Prefix IndicesRobert DiFalco17 Oct