Can I get an explain plan from Enterprise Guide before submitting, so I can see what will actually get passed to database?

[LinusH]

Well, why didn't you try it before asking us?

[jwycoff]

Sorry, Not seeing how this was relevant OR helpful... ??

[ChrisHemedinger]

Joel,

Thanks for using the community -- I hope that the discussion in the original thread was helpful to you.  If there are unresolved issues, please add more detail into the original thread about what you've tried already.

I think that Linus probably saw your code example and assumed that, since you hadn't posted the result of any attempts, that you didn't try it.  But I assume that you did try your sastrace options and maybe didn't get the results you wanted.

In these communities it's regarded as a good practice to share as many details as you can, including what solutions you've already tried with their results.  The folks who answer lots of questions here simply want the best chance at providing an answer that will fit your situation.

Also -- a side note -- English is not the first language for everyone here, so sometimes responses can come across sounding a bit curt to native English speakers.  We appreciate that responders are trying their best to help our global audience.

Thanks,

Chris Hemedinger

Manager, SAS Online Communities