Rong, > I have a select like this: > > SELECT MAX(transactionid) FROM cbntransaction WHERE transactiontypeid=0;
Simple workaround: Create an mulit-column index on transactiontypeid, transactionid. SELECT transactionid FROM cbtransaction WHERE transactiontypeid=0 ORDER BY transactionid DESC LIMIT 1; This approach will use the index. Of course, if the reason you are selecting the max id is to get the next id, there are much better ways to do that. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend