Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
One way this is prevented in well-run shops is that stored procedures must be signed off by the dba - which prevents sneaking something in that will use an unacceptable amount of resource.
IMHO, it depends on if the process needs more time because of the amount of real work it does rather than being inefficiently implemented. Better to improve a poor process once than to run it "forever" wasting resources.
This often happens when a "simplest for the programmer" solution is used rather than a proper solution.
It is far more important to learn to implement good code than to learn to get around safeguards. . .