QUERY ON TIMESTAMP COLUMN

[Yusuf Gangat]

Hi   I have a table called TRANSACTIONFILE that has 15 fields and about 3 million records and will continue to grow. One of the columns is a timestamp column and even though it is indexed it takes a long time to bring back a result based on that column as a search criterion. An example of my query is :  “SELECT * FROM TRANSACTIONFILE WHERE TRANSACTIONDATE >= ‘2000-01-01 00:00:00’ AND TRANSACTIONDATE <= ‘2000-12-31 00:00:00’ ” which brings back all transactions for the year 2000.   Is there any way of speeding this query up or is 15 to 20 minutes an acceptable time for the above query? Or is the volume of data in the table too much?   Any help will be greatly appreciated     Thanks in advance Yusuf --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.465 / Virus Database: 263 - Release Date: 3/25/2003