[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Originally posted by Jeanne Boyarsky:
Jayesh,
Show him the execution plan itself!
I don't know of any sites/articles on the subject, but I imagine you could find one by searching on the web.
Originally posted by Martin Locher:
Which RDBMS are you running Oracle ?
If yes tell youre DBA he should run "analyze table" for the tables used in the sql statement.
Consider Paul's rocket mass heater. |