Hi
I’m looking for an MS SQL Expert to help us with the following SQL Query. The query is very slow due to the two subselects. Can you optimized the query to perform better.
CREATE VIEW V_DEVICE_CAPABILITY_FALLBACK_VENDOR_MODEL AS
SELECT (
SELECT TOP 1 DEVICE_VENDOR
FROM V_DEVICE_CAPABILITY_FALLBACK a
WHERE [login to view URL] = [login to view URL]
AND a.DEVICE_VENDOR IS NOT NULL
ORDER BY [login to view URL] ASC
) AS DEVICE_VENDOR_FALLBACK, (
SELECT TOP 1 DEVICE_MODEL
FROM V_DEVICE_CAPABILITY_FALLBACK b
WHERE [login to view URL] = [login to view URL]
AND b.DEVICE_MODEL IS NOT NULL
ORDER BY [login to view URL] ASC
) AS DEVICE_MODEL_FALLBACK, c.*
FROM DEVICE_CAPABILITY c
Please let me know if you can help me.