homehome previousprevious nextnext
 
Setting Single- and Multi- Field Indexes

To include field(s) in the index, just simply double-click the Field Names field or click to open the editor for editing.


Select the field(s) from the list. To remove the fields from the index, uncheck them in the same way. You can also use the arrow buttons to change the index field(s) order. The Sub Part edit box(s) is used to set index KEY LENGTH (1 - 255).

Note: Some of data types do not allow indexing by several fields. For example: BLOB

 

Copyright 1999 - 2007. PremiumSoft TM CyberTech Ltd All rights reserved
MySQL TM is a trademark of MySQL AB in the United States and other countries.