|
|
|
|
|
by fallingfrog
1518 days ago
|
|
Yeah, but in my experience, DB query optimizers are terrible. Ideally you'd be able to write "select * from A, B, C where A.col1 = B.col2 and B.col3 = C.col4", but in practice, you have to hold the SQL interpreter's hand by using inner joins and carefully choosing which table to start with and what order to join them, in effect doing the query optimizer's work for it. |
|