Indexing Question

From: Darwin Weyh (
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." 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.


Darwin C. Weyh
And for the spammers: