Category "query-performance"

SQL How to get categories that don't contain products?

SELECT DISTINCT {c2.name} FROM {BrandCategory AS c JOIN CategoryProductRelation AS c2p ON {c.pk} = {c2p.source} JOIN Product AS p

Function Based Index not improving query performance

I have created view and in this view i have added the below case statement which i need and for which i already create exactly the function based index. The vie

Other Categories