[MonetDB-users] Inner join & nulls performance question
15 Jul
2009
15 Jul
'09
12:02 p.m.
Hi, I want to do a join between tables on a column that contains nulls. What should I expect performance-wise when running SELECT ... FROM... INNER JOIN... ON (a.f1 = b.f1 OR (a.f1 is null AND b.f1 is null)) compared to a normal join: SELECT ... FROM... INNER JOIN... ON (a.f1 = b.f1) Thanks. -- View this message in context: http://www.nabble.com/Inner-join---nulls-performance-question-tp24496517p244... Sent from the monetdb-users mailing list archive at Nabble.com.
5645
Age (days ago)
5645
Last active (days ago)
0 comments
1 participants
participants (1)
-
Alex Bo.