I have a very simple database, one table with five columns (one INTEGER key, two VARCHAR, a DATE, and a DOUBLE). The table contains 909,000 records.
A simple query like
SELECT t.price FROM commoddb.tbcommodprices t WHERE t.ticker='LAV05 Comdty' && t.whichprice='last' && t.date = '2005-09-01'
takes over 1.6 seconds to respond to a local query, which seems very slow. I would appreciate any suggestions for ways to speed this up.