Archive for December, 2008

Useless joins…

Sunday, December 28th, 2008

Sometimes when you’re building queries you end up joining tables which you don’t really need (anymore). They are just there to join some other table from which you do need some data. The join is just there to satisfy some foreign key references. It can however greatly impact the speed of your query. If the [...]

Filed under: Oracle, SQL | No Comments »

Code refactoring…

Friday, December 12th, 2008

Steven Feuerstein wrote an entry on his Toadworld blog where he checks the refactoring capabilities of SQL-Developer.
I am trying the same things in PL/SQL Developer to see if this does do the trick.

Filed under: Oracle, Tools | 4 Comments »