|visits||member for||2 years, 4 months|
|seen||Nov 6 at 23:26|
Over use of Oracle With Clause?
To be more specific the individual who told me this was a OCP certified SQL developer with a masters in computer science. He works at a large hospital in southern California. He said that their main reporting server had crashed from the overuse of with clause by report developers eating up server resources. Which spawned this question. He noted that the hospital DBAs had since restricted when the report developers use the with clause.