Re: sysstats question

From: Pratap Singh <singhp_at_BACTC.COM>
Date: Wed, 3 Jan 1996 14:52:09 PST
Message-Id: <9601032251.AA21328@alice.jcc.com>

At 12:01 PM 1/3/96 -0800, you wrote:
>I'm making the ASSumption that the values:
>"table scan rows gotten" and "table fetch by rowid"
>from v$sysstats are mutually exclusive...???
>I other words a fetch by rowid denotes an index look up and scan rows gotten
>denotes full table scan...?????
>????
>
>dlt3716_at_kcpl.com
>

Hi

Fetch by rowid is always index lookup.
and scan rows are mostly *full* table scans except for range scan cases where I am not sure.

Have a nice day.

---

Pratap Singh

Email: singhp_at_bactc.com
Voice: 415-827-5868
Fax: 415-266-6324

---

Wishing you a happy and prosperous new year.

---

Received on Wed Jan 03 1996 - 17:51:11 CST