All Questions

Filter by
Sorted by
Tagged with
2
votes
1answer
29 views

selecting next todo item from child table

I've a table with millions of records, relationship is one (object) to many (object_items). object_items: CREATE TABLE `object_items` ( `item_name` varchar(50) NOT NULL DEFAULT '', `object_id` ...
2
votes
1answer
2k views

Should i use subquery to limit table before a join?

In the case of a join followed by a where clause, would it be better to use a subquery to limit the results, and then do the join? Example: SELECT * FROM Customers NATURAL JOIN Orders WHERE ...