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. __________________________________________ Yahoo! DSL Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings