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, 10 lines --] > > 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! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]