|
Three Tips Most Excellent for PL/SQL Developers |
|
StevenFeuersteinTW
|
Monday, October 30, 2006 4:58 PM
|
|
|
|
Welcome to my Toad World blog! I will offer on this blog a wide variety of tips and incredibly deep and surprising insights on the Oracle PL/SQL language (the object of my obsessive personality for the last 10+ years). I look forward to your responses and critiques. That is: I hope you will engage with these ideas and feel perfectly comfortable with disagreeing with me, offering other, perhaps better, i ...
|
 |
|
Comments (7)
|
Read More...
|
|
|
Why SQL Tuning? |
|
RichardTo
|
Monday, October 30, 2006 2:28 PM
|
|
|
|
For years, commercial database manufacturers have fought an endless battle to improve the performance of inserting, updating, deleting, and retrieving information stored in the database. Despite their continual efforts and hard work, we have not seen a significant improvement in the performance of most Relational Database Management Systems (RDBMS). Users still suffer from under-performing SQL statements and database expe ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Why Reverse Engineering is Always Worthwhile |
|
Bert
|
Monday, October 30, 2006 1:04 PM
|
|
|
|
In many shops that I visit, neither the DBA’s nor the database developers place much value on performing data modeling. Often there are seemingly sound reasons for this exclusion: the historically high price of data modeling tools, data models are not required as a project milestone or deliverable, and quite often the database was simply either inherited or supports a third party application – ...
|
|
|
|
Comments (1)
|
Read More...
|
|
|
Changes in SQL Tuning |
|
MikeA
|
Wednesday, October 18, 2006 4:54 PM
|
|
|
|
When I started working with Oracle in 1990 there weren’t many SQL tuning tools available. At most you had the Oracle supplied tools which allowed you to capture an explain plan and minimal tracing. Most SQL tuning consisted of either encouragin ...
|
|
|
|
|
Read More...
|
|