Eric P on Nostr: nprofile1q…4h82d It's particularly helpful with inner joins where you only care ...
nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqln5q8np5aezhtt7ztv6tah86xk4t3smjuchdvxp0u6uta056204qf4h82d (nprofile…h82d) It's particularly helpful with inner joins where you only care about a condition being true in another table.
I still like to list out my columns rather than doing '*' if I can help it. That ensures that I'm fetching only the data I need rather than discarding data I don't.
The query optimizer also sometimes picks better plans based on what is being selected. (e.g. select indexed_col from table would be a index scan rather than table scan)
I still like to list out my columns rather than doing '*' if I can help it. That ensures that I'm fetching only the data I need rather than discarding data I don't.
The query optimizer also sometimes picks better plans based on what is being selected. (e.g. select indexed_col from table would be a index scan rather than table scan)