dasari4kntr Posted September 7, 2023 Report Posted September 7, 2023 read the comments...in this tweet... its worth reading these comments... Quote
libraguy863 Posted September 7, 2023 Report Posted September 7, 2023 1 hour ago, dasari4kntr said: read the comments...in this tweet... its worth reading these comments... I think query 2 as the values are filtered with id=data.id but in the first query all the records are pulled from the sub query so thats my take .. explain me if im wrong. 1 Quote
Konebhar6 Posted September 7, 2023 Report Posted September 7, 2023 1 hour ago, dasari4kntr said: read the comments...in this tweet... its worth reading these comments... I will delegate this to my team Quote
jalsa01 Posted September 7, 2023 Report Posted September 7, 2023 5 hours ago, dasari4kntr said: read the comments...in this tweet... its worth reading these comments... First query but Depends on big table size Quote
dasari4kntr Posted September 7, 2023 Author Report Posted September 7, 2023 9 hours ago, libraguy863 said: I think query 2 as the values are filtered with id=data.id but in the first query all the records are pulled from the sub query so thats my take .. explain me if im wrong. 6 hours ago, jalsa01 said: First query but Depends on big table size it depends on the nulls bro… check the tweet comments…lot of good discussion… Quote
DallasKarreBalu Posted December 27, 2023 Report Posted December 27, 2023 On 9/7/2023 at 8:54 AM, dasari4kntr said: it depends on the nulls bro… check the tweet comments…lot of good discussion… ok Quote
Mr Mirchi Posted December 27, 2023 Report Posted December 27, 2023 when i design a table...i always try to avoid nulls with default values...if possible.. null ...c0rrest dasari Quote
Spartan Posted December 27, 2023 Report Posted December 27, 2023 1 hour ago, Mr Mirchi said: when i design a table...i always try to avoid nulls with default values...if possible.. null ...c0rrest dasari agree nulls should not be the default value Quote
LungiLingaraju Posted December 27, 2023 Report Posted December 27, 2023 No twitter account uncle Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.