At 18:45 -0500 10/22/02, stoughto@stripped wrote:
>Indeed, setting MAX_ROWS lets me create the index. Thanks for the tip.
>How would I find out what the MAX_ROWS setting on a table is?
SHOW CREATE TABLE tbl_name;
SHOW TABLE STATUS LIKE 'tbl_name';
>----- Original Message -----
>From: Ken Menzel <kenm@stripped>
>Date: Tuesday, October 22, 2002 4:05 pm
>Subject: Re: How to index a large table?
>> Just curious Chris, did you set MAX_ROWS option during table create
>> to a really large value? If not alter the the table with this and try
>> again, it affects the size of pointers used to create the index.
>> (See CREATE TABLE in the manual)
>> Hope it helps,
> > Ken
|• Re: Re: How to index a large table?||Paul DuBois||23 Oct|