on what basis we will say Badly constructed SQL,

sudheerkmf · New User Joined: 24 Nov 2006 Posts: 2 Location: Pune

for finding the poor performance.

what basis we will say badly construted Sql

hariavinash · New User Joined: 04 Jan 2006 Posts: 64

query not optimized based on keys..
table scan..
cartesian product.. are few to start with.

cheers

ravi17s · New User Joined: 15 Aug 2003 Posts: 57

Response Time of the query.

have look ino the Plan table if you have access,check for the attributes like Type of scan,match columns,list prefetch.JOIN METHOD...
sorting requirements.............

Thx,
Ravi.

sudheerkmf · New User Joined: 24 Nov 2006 Posts: 2 Location: Pune

ravi

how we can look into plan table,
could you please expalin the procedure.

we alreday exected queries in production like withh order, with out order

but we didnt get any differnce in the sql execution time.

thx
sudheer

ravi17s · New User Joined: 15 Aug 2003 Posts: 57

When your are binding the program
will u give an option EXPLAIN(YES)
then thie will populate the values into the plan table.

normally plantable will will be named as

PLAN_TABLE with ur qualified object owner

XXXXXX.PLAN_TABLE
following checklist to see that you have not overlooked some of the basics:
?Is the query coded as simply as possible??
?Are all predicates coded correctly??
?Are there subqueries in your query??
?Does your query involve aggregate functions??
?Do you have an input variable in the predicate of an SQL query??
?Do you have a problem with column correlation??
?Can your query be written to use a noncolumn expression??

Post the query.........Somebody can help you........
Or contact your DBA's