> On 3 Sep 2003 at 18:59, eli wrote:
>
>> EXCEPTION java.sql.SQLEXCEPTION:Invalid argument value, message from
>> server "Two many key part specified. Max 16 parts allowed".
>> [...]
>> INDEX(ID, Field_1, Field_2,Field_3,.... Field_23)
>> )
>>
>> I was supossed the maximum number of index was 32.
>
> The maximum number of indexes is not the same as the maximum number
> of parts for a single index. Somehow I doubt you really want a
> single index on 24 fields. Having Field_23 at the end of the index,
> for example, is useless unless you're already specifying all of ID
> and Field_1 through Field_22 in the query as well.
Thanks. It was very useful. I realized I was wrong writting indexes.
eli
________________________________________________________________________
SetFile DATABASE FACTORY
- Aplicaciones a Medida en FileMaker Pro ( Windows y Macintosh )
<[EMAIL PROTECTED]> <www.setfile.com/es> TEL 93 238 56 00
FileMaker Inc es miembro del BSA ( 900 211 048)
SetFile - FSA Partners
________________________________________________________________________
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
