Author: SSWUG Research

Community

Cardinality errors across joins

(Bobby Durrett) We have been discussing query tuning at work and I’ve come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned by a query. I want to show that it is easy and common to have queries that the optimizer ca

Community

Radio Buttons with AngularJS

(K. Scott Allen) Last week we looked at using ngOptions in AngularJS to build a select list. Since the selections are mutually exclusive, we could have done something similar using radio buttons. There is no directive dedicated to radio buttons, but here’s a couple examples to show how easy they are

Community

Introduction to SQL, Part 5

(James Buck) An additional feature of the Run SQL Scripts interface is SQL Assist. This feature allows the user to create fairly sophisticated SQL statements with little or no knowledge of SQL. Although you should learn to write SQL statements without depending on a feature such as SQL Assist, this