Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Conditional relationship for multiple tables

Hi,    I have 4 tables    logins, ConnectedUsers,FacilityCode, ProviderCode.      Basically in ConnectedUsers table i have:  Provider_Name System_Code Facility_Code RegisteredUsers AH...
CALCULATE
COUNT
lbendlin's avatar
lbendlin
Super User
5 years ago

If you want to be cute you can rewrite

 

IF(ISBLANK( [Facility_Code]) ,[System_Code], [Facility_Code] )

 

as

 

COALESCE ( [Facility_Code]) ,[System_Code] )

 

but I'm not sure it would make any difference in performance.

d_gosbell's avatar
d_gosbell
Super User
5 years ago
but I'm not sure it would make any difference in performance.

No, they are identical in terms of performance producing identical query plans. COALESCE is just syntactic sugar over the IF( ISBLANK() ...) format