Re: Hello, newbie...

On Jan 26, 2:55 am, "jimbo" <bjorkman..._at_hotmail.com> wrote:
> Hello All,
>
> Can somebody point to links(or threads in this forum) for advanced SQL
> queries ? Especially tuning of SQL queries from programmers
> perspective(not DBA)?
>
> Any help will be much appreciated.
>
> Thx in advance.
>
> Jim

Several advanced SQL queries have been posted here and in the comp.database.oracle.misc group in the past several months, some by me, others by Michel Cadot, Maxim Demenko, and a large number of other people. There are often many ways to write a SQL statement. Generic methods that work on most databases will likely not perform as well as those that are written using Oracle specific syntax. It can be hard to determine the most efficient syntax. DBMS_XPLAN, 10046 trace, Oracle wait event interface, 10053 trace, and a stop watch will help determine the most efficient syntax.

How many ways can a single result set be obtained - the final post compares the performance of each method: "Limitting result without ROWNUM"
http://groups.google.com/group/comp.databases.oracle.misc/browse_thread/thread/1ce4e2a5bfa5d86e/6d3e5229c0c9c152

How many ways can a single result set be obtained... "Puzzles on SQL/Oracle More options"
http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/fbe588a109b3de20/675b91fe6d64bceb

How many ways can a single result set be obtained... "character count in a string More options" http://groups.google.com/group/comp.databases.oracle.misc/browse_thread/thread/3572ee04308f6a27/46381d60e8c8afd0

How many ways can a single result set be obtained... "Separate word in a field"
http://groups.google.com/group/comp.databases.oracle.misc/browse_thread/thread/211fed0f57c72f98/030ef74a6ad4c0f3

Other resources:
Oracle SQL Reference (read the analytical function section carefully): http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200.pdf

"Expert Oracle Database Architecture" - Tom Kyte

"SQL for Smarties" - Joe Celko

"Oracle SQL High-Performance Tuning" - Guy Harrison

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Fri Jan 26 2007 - 05:00:59 CST