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 doesn’t always mark an index as used even if it is used. If it isn’t used in an execution plan but […]

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 →