Use of SQL Queries and performance
Ok so I have a few queries that take time to run. takes a few minutes. Once I remove most of the items from the select statement it runs nice and quick.
Is there a way to use a temp table or something? I know how to do some basic sql but not the best with stuff like this.
i joined as below.
took 2 items from t3 (ac_identification) and 26 items from t4 (custom inventory)
Select DISTINCT t3.Name, t3.[OS Name], t4.*\
FROM [vCollection] t1 inner join
[CollectionMembership] t2 on t1.GUID = t2.CollectionGUID inner join
[Inv_Aex_AC_Identification] t3 on t2.ResourceGUID = t3._resourceGUID left outer join
Inv_Custom_Inventory t4 on t3._ResourceGuid = t4._ResourceGuid
WHERE t1.[Name] = 'MyCollection'
so any way to better write stuff like this? this is an example of say 15 that run slow.