Re: maximum number of indexes

2005-03-29 Thread SGreen
G M <[EMAIL PROTECTED]> wrote on 03/29/2005 01:54:17 AM: > hi all, > > in a table of say 100 fields, how many (maximum )numbers of indexes > can be created... > > thx in adv. > This is really just a math problem as the database limits are much smaller than the number of possible index combin

Re: maximum number of indexes

2005-03-29 Thread Gleb Paharenko
Hello. You may use: http://dev.mysql.com/tech-resources/crash-me.php especially see the 'Index limits' section. Not only the number of indexes is valuable, but, say, the length of index as well. G M <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 7bit, charset: us-ascii,

maximum number of indexes

2005-03-28 Thread G M
hi all, in a table of say 100 fields, how many (maximum )numbers of indexes can be created... thx in adv. - Do you Yahoo!? Yahoo! Small Business - Try our new resources site!