Home » SQL & PL/SQL » SQL & PL/SQL » Designing tables and queries for performance
Designing tables and queries for performance [message #199484] Tue, 24 October 2006 14:29 Go to next message
ajreynolds
Messages: 10
Registered: March 2005
Junior Member
Can anyone point me to a good book or web site with information on designing my tables, indexes, and queries for the best performance? I'm looking for something that can be done to speed up our systems from the developer's end of things, not the DBA.

I know you can make a big impact on performance through Oracle configuration and statistics, but I'm a developer, not a DBA. Also, our customers each have their own DBA's who each have their own ideas of how best to configure and maintain their databases.

Any tips or direction would be greatly appreciated.

Thanks,

Andy
Re: Designing tables and queries for performance [message #199485 is a reply to message #199484] Tue, 24 October 2006 14:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions

http://www.amazon.com/Expert-Oracle-Database-Architecture-Programming/dp/1590595300

supplemented by Oracle documentation.
http://www.oracle.com/pls/db102/portal.portal_db?selected=3
Re: Designing tables and queries for performance [message #199486 is a reply to message #199484] Tue, 24 October 2006 14:34 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Performance and tuning guide:
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96533/toc.htm

(some of it might be interesting for DBA's, but most is for developers Wink)

Regards,
Sabine
Previous Topic: Getting STATMENT CODE OF A TABLE
Next Topic: Disable All constraints in single SQL statement...
Goto Forum:
  


Current Time: Mon Dec 05 05:11:35 CST 2016

Total time taken to generate the page: 0.20218 seconds