How to tune this Parts Advance Search performance ?
I have following SDK query which is taking 18+ seconds to execute and 80+ seconds to iterate using the Iterator. How can we tune this query? Any suggestions?
[Title Block.Part Type (Subclass)] In (’75+ Part SubClasses’)
AND [Title Block.Lifecycle Phase] In 'Preliminary'
AND [Page Two.Created Date] Greater Than or Equal To ('11/16/2021 07:57:31 GMT')
AND [Title Block.Part Number] Not Like ‘*-*-*’
AND ([Title Block.ListAttribute] In (‘150+ List values’) OR [Title Block.ListAttribute] Is Null)
AND [Title Block.Description] Is Not Null