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