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
,
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 optimize the
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
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 have a