Re: How to find out about index

On 9 Oct 2002 at 14:45, Savita wrote:

> Hi all,
> 
> I have one more question regarding index.
> 
> I have 1 master table.
> 1 child table.
> I am creating a view out of this two tables.
> 
> When I used explain command it is showing sqg scan on master table ,even
> though I have created a index on some columns of master table

May be master table has relatively few records so planner considers a 
sequential scan better than indexed scan.

Bye
 Shridhar

--
union, n.:	A dues-paying club workers wield to strike management.