Hi All,
Can any one send me some links of web site that will help me to optimize my sql queries.

E.g.
we have table data,having many fields including a field sup_date.
i want to retriev all data between 06/30/2001 & 07/30/2001
for this which query will excute faster.
  1. select * from data where sup_date>='06/30/2001' and sup_date<='07/30/2001'
   2. select * from data where sub_date between '06/30/2001' and '07/30/2001'

Plese help;
Thanx in Advance.

Enjoy!
Subodh Kumar
Phoneytunes.com

__________________
<font size=\"2\"><font color=\"blue\"><b>Enjoy!
Subodh Kumar
Phoneytunes.com
</b></font id=\"blue\"></font id=\"size2\">

If you look at the query execution plan for those two queries in SQL Server, you'll see they are absolutely identical.

Make sure you have an index on the 'sup_date' column (maybe even the clusteered index) and that will be about as fast as it can get.

Sorry, I can't help you with any links.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com