Kevin Weslowski <[EMAIL PROTECTED]> wrote on 05/26/2005 02:20:46 AM:
> Hi,
>
> I've got a query that I believe should be giving me better performance
> than it is, since I've put indexes on all the appropriate columns...I'll
> include as much info as I can for anyone wishing to help me optimiz
Well, it seems you've helped solve my problem, Shawn...here we go:
first off, sorry about the text wrapping and the sloppy sql...I do get
lazy sometimes...I am a programmer :P
you asked how fast this runs:
SELECT ind_first_name
, ind_last_name
, fam_phone
, max(iat_dat
Hi,
I've got a query that I believe should be giving me better performance
than it is, since I've put indexes on all the appropriate columns...I'll
include as much info as I can for anyone wishing to help me optimize the
query/tables/indicies...thanks in advance for any assistance...
the que
I have a table which contains many items. Each item consists of an
scriptID, several attributes, and an optional field - a "parent" (called
"dupeitem" in the database) item. Most all of these fields are strings -
even the IDs which consist of a combination of letters and numbers. Items
which hav