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: 619
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: Tracking PL/SQL Code Changes
Next Topic: moths and dates
Goto Forum:
  


Current Time: Tue Aug 22 23:36:11 CDT 2017

Total time taken to generate the page: 0.06588 seconds