Re: How to find out about index

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

Any pointer???

Savita wrote:

> Hi all,
>
> I am new to postgre.I want to create index on some of the column.
>
> I just wanted to know that how to find out on which column we need to
> create index because using explain command I am not getting the clear
> picture as we get in oracle if we use the same explain plan command.
>
> I am unable to decide where should I create the index based on which
> criteria.
>
> Any help will be highly appreciated.
>
> --
> Best Regards
> - Savita
> ----------------------------------------------------
> Hewlett Packard (India)
> +91 80 2051288 (Phone)
> 847 1288 (HP Telnet)
> ----------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------