Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Optimizing queries

 
Mallika Kumar
Ranch Hand
Posts: 61
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have a query tool which gets results based on inputs provided by users. I have several different SQL JOIN statements involving 6-8 tables in each query. Some involve outer joins too. I would like to know what steps should be taken to make these queries efficient and quick.
I have been using the concept of having the smallest table first in the FROM clause, and the largest(in terms of rows) at the end of FROM clause. Alongwith this, I'm trying to put the most important JOIN CONDITION first in the WHERE clause. I'm using Oracle 8i, and PreparedStatements to execute these queries.
Any suggestions would be helpful.
Thanks.
 
Daniel Dunleavy
Ranch Hand
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think the most important thing to look at is your indexes. Which indexes to create, and to make sure they are used when the sql executes. Perhaps using HINTS in the SQL if you think Oracle will not choose the quickest path. If you have very small tables, you don't need indexes because the entire table will be pulled in.
Dan
[This message has been edited by Daniel Dunleavy (edited May 21, 2001).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic