Re: views & indexes

• Use Optimizer hints (such as /*+ index(TABLENAME INDEXNAME) */ )
• Put the table with the least records at the last of our select list Example: Tables x1,x2,x3 x3 has the leasts records select ....... from x1,x2,x3

Try the statement with svrmgr or sqlplus with set timing on.

"An optimizer is always doing what he wants !!!"

Steve wrote:

> when I execute a select from a view how do i insure that
> the view select stmt is using indexes?
> My view select stmt does include a 'union', reads from three
> different tables.
> Does the view select stmt. use the data passed in from the
> select stmt. to the view?
> Right now my explain plan shows a full table scan on 2 tables.
> And twice because of the union.
> Is there a better way?
> Any help appreciated.
> Thanks,

--
-------------------------------------
ADICOM Informatik GmbH
Andreas Michler
Wiesfleckenstr. 34
72336 Balingen
Tel: 07433/9977-57,Fax: -90
E-Mail: Andreas.Michler_at_adicom.de
http:\\www.adicom.de
-------------------------------------