Indexing Question

From: Darwin Weyh (shtdev.delete.this_at_weyh.net)
Date: 10/04/04


Date: Mon, 4 Oct 2004 09:34:51 -0400

I have a VB6 application in which I access a FP6 DB with ADO.

As one of the tables gets bigger ( 20,000 Records) My response is degrading.

A typical Recordset open is as follows

SQLstr = "select * from orders where jobdate < {" & pDate & "} and complete
= .T."
RS.open sqlstr,db, adOpenStatic, adLockReadOnly

What kind of index should I set up to speed this open up?

Can someone point me to a good explanation of Indexes and how they relate to
the SQL 'select' commands.

Thanks,

-- 
Darwin C. Weyh
shtdev.delete.this@weyh.net
And for the spammers: dweyh@weyh.net