Message-Id: <10569.112838@fatcity.com> From: Kamesh.J.Mantri@citicorp.com Date: Tue, 25 Jul 2000 13:39:36 +0530 Subject: RE: Is this a performance issue? Actually this is not a performance issue bcos when Oracle fetches rows for a select it does in with implicit cursor which goes row by row not column by column. Even if we mention a single col it fetches the whole row. Gurus correct me I am wrong.. Kamesh. -----Original Message----- From: schanna [mailto:schanna@att.com] Sent: Monday,July 24, 2000 9:07 PM To: ORACLE-L Cc: schanna Subject: Is this a performance issue? Gurus, I'm wondering if it's a performance issue if i select all the columns from a table even if you don't require. Let say I have a table which has about 50 columns in it and i need to get values for only 5-10 columns. So, instead of selecting only these columns I select *. Any idea if that screws up my performance? Santhosh Babu -- Author: Channa, Santhosh, SITS INET: schanna@att.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).