I have a dynamic query with around 8 buffers and I've noticed that the QUERY-OPEN statement is slow. It's taking around 330 milliseconds to perform this action.
Is this normal? If not, what should I be looking at to try to resolve the issue?
Is the same query slow when you make it a static query or a for each? If so, then look at the usual query suspects: indexing etc.