- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Help with Oracle Sql tuning anybody
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-11-2003 07:10 AM
тАО09-11-2003 07:10 AM
Help with Oracle Sql tuning anybody
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-11-2003 12:12 PM
тАО09-11-2003 12:12 PM
Re: Help with Oracle Sql tuning anybody
Make sure that your tables have been analyzed recently.
Get off of Oracle 7.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-11-2003 06:36 PM
тАО09-11-2003 06:36 PM
Re: Help with Oracle Sql tuning anybody
In your query, you have a lot of not null values (nvl). Yoy can redice this checking, it the field had a not null constraint, If the some of these fields can be defined as not null when the data is inserted intot he table (like define a not null constraint on this field in the table), then you do not have to check for nvl each time you query.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2003 04:55 AM
тАО09-12-2003 04:55 AM
Re: Help with Oracle Sql tuning anybody
Look at the from clause.
Under 7.3.4 with "RULE", I think the tables are scannned starting from the last one to the first one. So your "sl" table should be specified last.
Organize the table list so the tables are scanned from last to first.
There could be a little problem with that when you migrate to higher versions with "COST" where the order will be reversed. Learn the use of hints.
Take care.
Ray
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2003 05:20 AM
тАО09-12-2003 05:20 AM
Re: Help with Oracle Sql tuning anybody
Mel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2003 08:37 AM
тАО09-12-2003 08:37 AM
Re: Help with Oracle Sql tuning anybody
http://www.wsl.ch/relics/rauminf/riv/datenbank/general/tinalondon.html
All of the ANDS mean exclusivity. I would consider changing the where clause to have the AND that is likely to "excludes" most of the data first. You of course knows your data.