Hi there everyone, How does indexing work, and does it speed up small / average size DB's of around 20,000 records, with 12 columns per record? (Some columns being paragraphs of text). Also, do you create an index on everything or just 1 item or or or :-) I've not looked at indexing but think it's time to start, but in a way even I can understand so I thought i'd ask you all here :-) Thanks Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php