| How does Oracle process queries. [message #228827] |
Wed, 04 April 2007 06:05  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
