Hi, > WHERE > col1 > <something> AND col2 > <something> etc... > AND PRIMARYKEY > 0; [...skip...] > I need an explanation of whether what I did is an > optimization or not? Or should i be looking into something > else to actually optimize the query.
The best way to optimize it is would be to add an index for some or all the columns from the WHERE clause. Once you do that you will not need the `AND PRIMARYKEY > 0` part and the query will truly be using the index to improve the performance. Best regards, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
