Re: Re: How to index a large table?

[Paul DuBois]

sql,query


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;

or

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