On 1/10/06, Mark <sendmailtomark@yahoo.com> wrote:
> Hello,
>
> When I run 'explain analyze' on a query, how do I know what index is
> used and is it used at all. What are specific words should I look
> for?
>
> Is "Seq Scan" indicates that index has been used?
> How do I know that it was Full Table Scan?
>
> Thanks,
> Mark.
>
"Seq Scan" is short for Sequential Scan (Full Table Scan)...
you have to look for the word index to see what indexes are you using
if any (the name of the indexes are used too, so if you now indexe's
names you can find them in the explain analyze quickly)
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)