RE: Is this a performance issue?

From: Tom Best <Tom.Best_at_bentley.com>
Date: Tue, 25 Jul 2000 15:49:37 -0400
Message-Id: <10569.112930@fatcity.com>

Probably means setting the pctthreshold in the IOT such that the column data is stored separate from the primary key, on another disk, thus possibly increasing performace.

-----Original Message-----
From: Siva_Chintalapati [mailto:Siva_Chintalapati_at_satyam.com] Sent: Tuesday, July 25, 2000 3:34 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Is this a performance issue?

What are dangling columns.

Regards
Siva

---

From: Glenn Travis[SMTP:Glenn.Travis_at_wcom.com] Reply To: ORACLE-L_at_fatcity.com
Sent: Tuesday, July 25, 2000 10:27 PM

To:     Multiple recipients of list ORACLE-L 
Subject:        RE: Is this a performance issue? 

	Unless all columns can be satisfied with an index (but you already

knew
that, right?).

        If you have are selecting 5 columns, and say, three of them make up an
index, you may want to consider storing the other two in the index as dangling columns. Depending on your table size, joins to other tables, performance needs, this could be a real win...

        > -----Original Message-----
> From: root_at_fatcity.com [ mailto:root_at_fatcity.com <mailto:root_at_fatcity.com>
]On Behalf Of
> Kamesh.J.Mantri_at_citicorp.com
> Sent: Tuesday, July 25, 2000 5:24 AM
> To: Multiple recipients of list ORACLE-L
> 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-----
> Sent: Monday,July 24, 2000 9:07 PM
> To: ORACLE-L
> Cc: schanna
>
>
> 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_at_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_at_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).
>
> --
> Author:
> INET: Kamesh.J.Mantri_at_citicorp.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_at_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).
>

        --
Author: Glenn Travis
  INET: Glenn.Travis_at_wcom.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_at_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 Received on Tue Jul 25 2000 - 14:49:37 CDT