Ask the Expert

Using traditional and RMAN backup at same time

  1. Could I use both the traditional and RMAN backup at the same time?
  2. Do I need to re-index the table if there is a change in the structure?
  3. I have a table ABC with columns A1, A2, A3, A4, A5, A6 and A7. My index is A1, A2, A3, A5. When I run a query using only A1, A5 in the where clause, is it using the index?
Thanks.

    Requires Free Membership to View

You can definitely use the traditional (user-managed) hot and cold backups in conjunction with RMAN backups. But recovery from these different backups is different. RMAN can only use the RMAN backup for recovery, similarly for the user-managed backups. Make sure you practice recovery from each backup type under a variety of scenarios.

You do not need to re-index a table if you change the table's structure unless your structural change involves the index. Simply adding a column to a table will not affect any exisiting indexes. Dropping a column can affect an index if the index uses that column.

The only way to know for sure if your query is using any index is to run the query through EXPLAIN PLAN. This will tell you how Oracle is executing the query. Depending on your configuration, the index may or may not be used.

This was first published in February 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: