February 2012

Index monitoring – things to keep in mind

For those not familiar with it, index monitoring is Oracle’s way to track whether an index is being used, letting you know if it is needed. Two things to keep in mind: 1) It gets marked as used if it is used in a query plan, but there are other reasons you may need the […]

Read more →

Querying multiple rows from dual

Sometimes it’s useful to have a query that always returns a certain number of rows, such as a report that returns one row for every day of the month. Using DUAL and CONNECT BY allows you to return as many rows as needed. For instance, this query returns one row for every day of the […]

Read more →