On 1/10/06, Mark <[EMAIL PROTECTED]> 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 ;)
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
