This is a one page list of simple guidelines to tune SQL without much DBA knowledge.

Sample of points are listed as below.

# Understand the data. Look around table structures and data. Get a feel for the data model and how to navigate it.
# If a view joins 3 extra tables to retrieve data that you do not need, don't use the view!
# When joining 2 views that themselves select from other views, check that the 2 views that you are using do not join the same tables!

[url=http://www.oraclepoint.com]nbei3wZc9OraclePointlEvnt4v9D[/url]

# Avoid multiple layers of view. For example, look for queries based on views that are themselves views. It may be desirable to encapsulate from a development point of view. But from a performance point of view, you loose control and understanding of exactly how much task loading your query will generate for the system.
# Look for tables/views that add no value to the query. Try to remove table joins by getting the data from another table in the join.

Please find complete list at attachment.