Re: Need optimization in query

2022-06-13 Thread Shubham Mittal
Hi Team, Does anybody tried to have a look at it and would like to suggest any optimisations? Thanks On Sat, Jun 11, 2022 at 12:48 AM Shubham Mittal wrote: > Hi Team. > > *I have a use case to get the result as follows:* > > 1. asin_ymm is never null. > 2. If there is more than 1 entry for an

Need optimization in query

2022-06-10 Thread Shubham Mittal
Hi Team. *I have a use case to get the result as follows:* 1. asin_ymm is never null. 2. If there is more than 1 entry for an asin_ymm with both null and non-null submodelId, I should return rows with non-null submodelId only, otherwise if there is no submodelid present for a asin_ymm, then retur