Re: Index - To use OR Not ?

[Greg Moore]

Title: process size limitation on HP-UX

>> Qs. How is the Number of Block Visitations to be Found for Both the Index Scan & Full Table Scan ?   You could use Autotrace.  That will show blocks read, indicating logical and physical reads.  You could also use TKPROF. ----- Original Message ----- From: VIVEK_SHARMA To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 13, 2002 6:33 AM Subject: Index - To use OR Not ? Gaja Wrote in his Book 101 Performance Tuning   "When Running an SQL Query Avoid using Indexes when an index scan performs More Block Visitations Than a Full Table Scan"   Qs. How is the Number of Block Visitations to be Found for Both the Index Scan & Full Table Scan ?