MYSQL - INDEXES

[emailroy2002]

I HAVE A PROBLEM WITH THIS>>>

Whats the use of indexing in MYSQL

Someone explain, pls... anyideas pls post... very much appreciated

[simoncpu]

MySQL indexes are hash tables (more or less) that the DB uses to optimize certain operations. When you need to find a certain row, you just refer to the hash table without looping through the entire DB table. You can find a good discussion on hash tables here:

http://en.wikipedia.org/wiki/Hash_table

edit:

Less theoretical discussions here:
- http://dev.mysql.com/doc/refman/4.1/...l-indexes.html
- http://www.xaprb.com/blog/2006/07/04...optimizations/

[ simon.cpu ]

[cute_poison]

Just think this way. Indexes were made to fetch data more faster. Databases has its own way in handling indexes. A quick note, if you want to add indexes to your tables it should be at least a column that frequently used in your where clause. Like if you have table Orders, you can make index for order_no column. Hope this help out.

[silent-kill]

sakto si simon. mora ang "text" man basin to dili pwede ma index. sakto bah?