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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: PaulDeason
- Order by date
-
Multiple Column Indexing
The database is a job search so the columns are things like industry, company, location, job type, salary. However, apart from salary, the other columns will be integer keys to other tables that have pre-defined options. The problem is people search for jobs on completely different criteria...- PaulDeason
- Post #4
- Forum: MySQL
-
Multiple Column Indexing
I want to use multiple column indexing to improve my SELECT queries. I have 5 columns that can be searched on, however, anywhere between one and five of the columns can be searched on depending on the user. Therefore if the user searches on e.g. column 1 and 3, a normal multiple column indexing...- PaulDeason
- Thread
- Replies: 3
- Forum: MySQL
