| Alert Manager SQL vs Stored Procedure [message #460650] |
Sun, 13 June 2010 21:21 |
kenboss
Messages: 2
Registered: June 2010
|
Junior Member |
|
|
Hi,
I have an alert that pulls GL lines using two UNION ALL's. The performance is pretty slow even though all the right indexes have been implemented. I'm wondering if the performance would be faster if instead of entering the SQL directly into the Alert, I create a stored procedure instead. Is the SQL from an alert executed in the same way a stored procedure is executed? Or will the stored procedure be faster because it is stored and executed on the database server? Any insight is greatly appreciated.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
