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
ajreynolds
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.

Thanks,

Andy
Re: Where to go from here? [message #221482 is a reply to message #221426] Tue, 27 February 2007 02:36 Go to previous message
JRowbottom
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: Tue Dec 06 12:11:14 CST 2016

Total time taken to generate the page: 0.05154 seconds