Tagged Questions
2
votes
1answer
117 views
Do you set an index on JOIN clauses or where clauses, or both?
Say my query looks like:
SELECT t1, t2
FROM t1
LEFT JOIN t2 ON (t1.id = t2.id AND t2.userid = @userid)
WHERE t1.enabled = 1 AND
t1.startDate <= ??? AND
(t1.counter = -1 OR
...
5
votes
2answers
229 views
Optimizing IP Range Search?
I have a simple query and table, and I would like to know which indexing is efficient on this kind of table and query.
In my table I have 3 columns
CREATE TABLE mYTable(ipFrom BIGINT, ipto BIGINT, ...
