Home » SQL & PL/SQL » SQL & PL/SQL » How does Oracle process queries.
How does Oracle process queries. [message #228827] Wed, 04 April 2007 06:05 Go to next message
sanjitpandey
Messages: 16
Registered: April 2007
Junior Member
I am trying to find out how the following querry is processed by oracle. The steps followed to execute the query of following nature. Can any body help me?
SELECT
a.field1,
a.field2,
a.field3,
SUM(field4) as Amt,
COUNT(*) as Count,
FROM
Table1 a,
Table2 b
WHERE
field3BETWEEN field5_CP AND field6
AND a.field1= b.field2 AND a.field3 = b.field3
AND a.field7 = 'test' AND NVL(field8, '') = 'N'
GROUP BY
a.field1,
a.field2,
a.field3

Thanks.
Re: How does Oracle process queries. [message #228835 is a reply to message #228827] Wed, 04 April 2007 06:39 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Look at EXPLAIN.
Re: How does Oracle process queries. [message #228995 is a reply to message #228835] Wed, 04 April 2007 22:32 Go to previous message
sanjitpandey
Messages: 16
Registered: April 2007
Junior Member
Thanks. I got that.
Previous Topic: Connection problem (network adapter cannot establish the connection) (Merged)
Next Topic: Capture dml statements fired on a database
Goto Forum:
  


Current Time: Fri Dec 02 22:57:26 CST 2016

Total time taken to generate the page: 0.10522 seconds