> "Martijn Tonies" <m.tonies@> > > > Design for understanding, logic and maintenance, not performance. > > > > If you need more performance, throw more hardware at it - > > a larger cache (settings -> memory), faster disks and a faster CPU. > > Or more indexes (which may require more hardware).
Oh yes, indices can help :-) Indices ONLY exist for performance reasons, not for anything else. That being said, wouldn't it be great to have a self-tuning database engine that would create indices after running your database application for a few days :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]