Toad World® Forums

Running SQL Optimizer on a production database without admin rights

For TOAD SQL Optimizer to be of any use to me, I need to be able to use it on my production data warehouse database without having the ADMIN role that is required for DBCC DROPCLEANBUFFERS.
Could Quest introduce an option to run the SQL optimization without doing this step?