Indexing Question
From: Darwin Weyh (shtdev.delete.this_at_weyh.net)
Date: 10/04/04
- Next message: David: "Password problem and ISAM"
- Previous message: U-CDK_CHARLES\\Charles: ""File Already In Use" when it's not in use?"
- Next in thread: Bob Butler: "Re: Indexing Question"
- Reply: Bob Butler: "Re: Indexing Question"
- Reply: Anders Altberg: "Re: Indexing Question"
- Reply: Val Mazur: "Re: Indexing Question"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: David: "Password problem and ISAM"
- Previous message: U-CDK_CHARLES\\Charles: ""File Already In Use" when it's not in use?"
- Next in thread: Bob Butler: "Re: Indexing Question"
- Reply: Bob Butler: "Re: Indexing Question"
- Reply: Anders Altberg: "Re: Indexing Question"
- Reply: Val Mazur: "Re: Indexing Question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
