Improving BAQ Performance

[Banderson (Brandon Anderson)]

@Arul

This thread will walk you through the index do’s and don’ts. (it’s where I learned it)

Unions and performance

So I have a query where I need to combine the JobAsm and JobMtl tables through a union. For some reason, the query takes a LONG time to run, even if I parameterize all levels to one (albeit large) job. Do all unions have performance issues? or is it likely that I could be doing something that is hurting performance?