Agile (MOSC)

MOSC Banner

How to tune this Parts Advance Search performance ?

in Agile (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center