What is the key to Oracle SQL Performance ?

Oracle SQL performance tuning is multidimensional in nature since it involves a lot of variables like underlying operating system, Oracle Server, network and SQL.

We are going to discuss SQL performance( assuming the other variables are working fine) and look at two key points that can help debug a bad SQL. To arrive at the two key points, we need to look how database technology has evolved lately.

SQL Performance

Read More
Comment

1000's of table

Came across this article on managing relational data from a very different perspective. Typically relational design in OLTP grows to 100’s of tables. When we have 100’s of table, we require each business change to have schema changes defined upfront, are more difficult to use with agile methods and a challenge to use in a continuously integrated environment without significant additional engineering.

SQL Performance  Design

Read More
Comment