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.