Create index on tables that are joined?

From: Stick With Hair <StickWithHair_at_gmail.com>
Date: Tue, 16 Oct 2007 10:47:15 -0700
Message-ID: <1192556835.604938.273760@z24g2000prh.googlegroups.com>

I have a table "ABC" which has 2 million records. A second table "XYZ" has 10 million records. I am joining ABC to XYZ and want to get all the records from ABC and only matches in XYZ (left join).

ABC --> XYZ On Fields:
CustName
CustTitle
CustPhoneNumber

The table XYZ has an index on those 3 fields but ABC does not. If I created an index on those fields in ABC will it help with query performance even though I am bringing in all the rows from ABC? I would guess that we need indexes on all foreign keys in both tables.

Any Suggestions or ideas?
Stick with hair Received on Tue Oct 16 2007 - 12:47:15 CDT