On Mon, Feb 19, 2001 at 10:22:58PM -0500, Paradox wrote:
I have a table with an integer auto increment primary key, INVNUM, and a
CHAR(48) field NAME.
Is there a way I can have my table presorted by the text field,
Yes, in 3.23.33 you can use myisamchk with the -R option. I don't have
a
Paradox ([EMAIL PROTECTED]) writes:
I have a table with an integer auto increment primary key, INVNUM, and a
CHAR(48) field NAME.
Is there a way I can have my table presorted by the text field, so that a
select call with "ORDER BY NAME" is just as fast as "ORDER BY INVNUM"? I
have tried