Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

indexing fields?

Status
Not open for further replies.
beco73

beco73

Programmer
May 8, 2005
157
CA
hi,

I have a table with product. I do search on 10 different fields on that table. If I make those fields index field will it make the search(queery) any faster?

thanks
 
Status
Not open for further replies.

Similar threads

waubain
  • Locked
  • Question
Show rows results on same row when Group BY fields 1
Replies
6
Views
364
SkipVought
S
Krio
  • Locked
  • Question
Help with query to ordering between fields
Replies
1
Views
63
Krio
Krio
Coza73
  • Locked
  • Question
Help with querying mutiple fields, filtering and outputing to single
Replies
1
Views
44
r937
r937
beatZin
  • Locked
  • Question
Custom Fields
Replies
0
Views
31
beatZin
beatZin
youradds
  • Locked
  • Question
Error when adding index to 2 fields
Replies
2
Views
52
youradds
youradds

Part and Inventory Search

Sponsor

Back
Top