A query joins some 5 tables. Two fields of a table are used in the where conditions .One is a primary key and the other is not indexed. We have planned to improve the performance of the query by indexing it.
My question comes here. Can it be indexed alone(it is not unique) or
togather with the primary key to create a unique index.
Which will be better.
Can someone help me.