> What's the nature of your query? > > If it's using an integer index and that's what your searching on, then > having > it physically sorted is a Good Thing. If you're table-scanning your > main table, you're toast anyway. Finding ways of making that faster is > the > way to go, maybe partitioning your data into "small, fixed width, > fields I > care about" and "other stuff" is the way to go? >
My tables are just 2 INT columns. I have unique indexes on them going both ways. Thanks Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]