Central Indiana Linux Users Group
User: Guest Log in |  Join
MySQL Presentation
First page Back Continue Last page Overview Graphics

Features -- Scalability and Limits

  • Up to 32 indexes per table are allowed

  • Each index may consist of 1 to 16 columns or parts of columns.

  • The maximum index width is 500 bytes (this may be changed when compiling MySQL Server).

  • An index may use a prefix of a CHAR or VARCHAR field


Notes:

Apr. 1, 2004 2:54 pm US/Eastern