Re: Indexing Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Val Mazur (group51a_at_hotmail.com)
Date: 10/06/04 

Date: Tue, 5 Oct 2004 22:29:10 -0400

Hi,

Usually you need to index combination of the fields, involved into WHERE
clause. Sometimes creating index on one field is enough. It is just a matter
of what you need to achieve with what kind of efforts. Best way is to play
with the indexes to see what is the optimal for the application. 

-- 
Val Mazur
Microsoft MVP
"Darwin Weyh" <shtdev.delete.this@weyh.net> wrote in message 
news:%23E$1ybhqEHA.1712@tk2msftngp13.phx.gbl...
>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
>

Relevant Pages

  • Re: Indexing Question
    ... clause. ... It is just a matter ... "Darwin Weyh" wrote in message ... > As one of the tables gets bigger My response is ...
    (microsoft.public.data.ado)
  • Re: Indexing Question
    ... clause. ... It is just a matter ... "Darwin Weyh" wrote in message ... > As one of the tables gets bigger My response is ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: Jumping around through forms
    ... matter of changing the ORDER BY clause instead of using the constant. ... Private Sub cmdFilter_Click ... Dim strWhere As String ...
    (microsoft.public.access.formscoding)
  • Re: Free State Security - part 2
    ... Whichever clause can stand alone as a complete sentence is ... part of the 2ndA, seems to be the crux of the whole matter, still. ... There is a case for this, and I'm not dismissing it, simply ... "popular" interpretation vunerable to dismissal at a later ...
    (talk.politics.guns)
  • Re: Search Condition in WHERE or JOIN?
    ... where is the best place to put search conditions - in ... It doesn't matter in the case of the INNER JOIN in your original post. ... clause rather than the JOIN clause for consistency and readability. ... LEFT JOIN titles ...
    (microsoft.public.sqlserver.programming)