|
View previous topic :: View next topic
|
| Author |
Message |
praba_jas
New User
Joined: 01 Apr 2005
Posts: 11
|
|
|
|
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. |
|
| Back to top |
|
 |
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| It can be indexed alone as a non-unique index and it can be indexed together with a unique index if you wanted that. |
|
| Back to top |
|
|
rajandhla
Active User
.jpg)
Joined: 18 Oct 2005
Posts: 182
Location: Luton UK
|
|
|
|
| i will go with william suggestion |
|
| Back to top |
|
|
|
|
