Home » SQL & PL/SQL » SQL & PL/SQL » Where to go from here?
icon5.gif  Where to go from here? [message #221426] Mon, 26 February 2007 13:27 Go to next message
Messages: 10
Registered: March 2005
Junior Member
I have been developing applications to work with Oracle for a while now and I can put together tables, indexes, queries, etc., but most of what I've done to this point is pretty brute force. I've found a few little tricks in my development environment (Magic) that speed things up a bit, but I don't really understand how to design things for best performance (speed). I don't know much on the DBA side of things, and each of my customers has their own DBA with their own way of doing things, so I don't have much control of the actual Oracle configuration.

Can anyone make some suggestions of what I can do when designing tables, indexes, queries, etc for the best speed? Any books or links?

I'd really appreciate any suggestions.


Re: Where to go from here? [message #221482 is a reply to message #221426] Tue, 27 February 2007 02:36 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Tom Kytes book Effective Oracle by Design is a good start.
Previous Topic: SQL
Next Topic: inserting regular expression in SQL Table.
Goto Forum:

Current Time: Thu Jul 20 11:36:09 CDT 2017

Total time taken to generate the page: 0.16075 seconds