Forum Moderators: open
CREATE TABLE Jobseekers
(
jobseeker_id int
LastName varchar,
FirstName varchar,
Address varchar,
Age int
)
CREATE TABLE Resumes
(
resume_id int,
jobseeker_id int,
Title varchar,
Objective varchar,
Education varchar,
Experience varchar
)
And the following query for example:
"Select From Jobseekers, Resumes WHERE Jobseekers.jobseeker_id=Resumes.jobseeker_id AND Resumes.Educations='Bachelors' AND Resumes.Experience='3 Years'"
I know how to create an index on a single table query. Do i need to create a different kind of index for a query on multiple table query? Thanks.
Indexed Views in SQL Server 2000 [sqlteam.com]