Speeding up my SQL statement
2004-06-29 06:51:15
Hi *SM-ers!
I'm using the following SQL statement to retrieve obsolete Oracle backup
files:
select node_name, filespace_name, ll_name, date(backup_date) from backups
where ((days(current_date) - days(backup_date) >= 100)) and hl_name='//'
This returns all Oracle backup files, created more than 100 days ago. These
should not exist anymore.
Since this statement scans ALL (millions!!) backup objects for a hit, it
runs for more than a day!
I'm looking for a way to reduce this, but I don't know how to do this.
If I would be able to limit the scan to only the objects belonging to Oracle
nodes (in our shop, the nodename ends with -ORC) it would finish much
quicker, but I don't know how.
Can anybody tell me if this is possible at all?
Thank you very much for any reply in advance!!!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential and
privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment may be
disclosed, copied or distributed, and that any other action related to this
e-mail or attachment is strictly prohibited, and may be unlawful. If you have
received this e-mail by error, please notify the sender immediately by return
e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM),
its subsidiaries and/or its employees shall not be liable for the incorrect or
incomplete transmission of this e-mail or any attachments, nor responsible for
any delay in receipt.
**********************************************************************
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Speeding up my SQL statement,
Loon, E.J. van - SPLXM <=
- Re: Speeding up my SQL statement, Lambelet,Rene,VEVEY,GLOBE Center CSC
- Re: Speeding up my SQL statement, Loon, E.J. van - SPLXM
- Re: Speeding up my SQL statement, Richard Sims
- Re: Speeding up my SQL statement, Loon, E.J. van - SPLXM
- Re: Speeding up my SQL statement, Prather, Wanda
|
Previous by Date: |
tcpadminport, Remco Post |
Next by Date: |
Re: Speeding up my SQL statement, Lambelet,Rene,VEVEY,GLOBE Center CSC |
Previous by Thread: |
tcpadminport, Remco Post |
Next by Thread: |
Re: Speeding up my SQL statement, Lambelet,Rene,VEVEY,GLOBE Center CSC |
Indexes: |
[Date]
[Thread]
[Top]
[All Lists] |
|
|