ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  More on JOINS
Subject:   Selecting Recordset
Date:   2003-03-29 02:29:11
From:   nithyaseshadri
Dear Mr.John Paul
With reference to your article - More on Joins dated 06/01/2001 ..there was a mention about SAVING by specifying the column names to be selected instead of using Select * from table..
I totally agree with it and would like to know in detail as to how this will effect when dealing with multitable complex-queries...
Please explain me the behavior of recordset with respect to MEMORY & SPEED in detail.


Thanking you
Nithya Seshadri