Display initials in view...bad performance. Help needed 1

[bridgeconsultant]

Hello,

We're getting bad performance when attempting to only display user initials on a report (using a view). Any ideas on a better way of getting user initials?

V2R5

SQL (FYI: if it was a null in the source, we put a '!' in the warehouse):

SELECT (CASE WHEN T9.ContactFirstName <> '!'
THEN SUBSTR(T9.ContactFirstName,1,1) ELSE '' END)||
(CASE WHEN T9.ContactMiddleName <> '!'
THEN SUBSTR(T9.ContactMiddleName,1,1) ELSE '' END)||
(CASE WHEN T9.ContactLastName <> '!'
THEN SUBSTR(T9.ContactLastName,1,1) ELSE '' END) UserInitials,


Help is greatly appreciated.

 

[JaC74]

You are hitting a look up table with this correct? or are you hitting a fact table to retrieve the names?

If you are hitting the fact table for the names, then show the whole SQL and the indexes to the fact table.

 

[bridgeconsultant]

Please disregard. I found a typo in the from clause (where it joins) in the developer's code.