I am using SQL server 2005
I have three tables, trying to figure which columns should i index. The tables are
The user searches in the Project table by ProjectId
The User searches in the Project_Users table by UserId.
The User searches in the Users table by UserId, Fname or Lname.
In your opinion which coulms in tables should be indexes?
Any ideas appreciated.