From: Date: October 17 2006 5:28pm
Subject: Prefix Indices
List-Archive: http://lists.mysql.com/mysql/202701
Message-Id: <1C21C32F5F592D48B16F28C7877D9BC13CB0D0@SVMAIL01.tripwire.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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".
=20
R.