How many rows are in this table? Sanjay wrote:
Hi All, Say I have a simple table WEBSITE(website_id int4 PRIMARY KEY, name VARCHAR(30)). While I try this: EXPLAIN ANALYZE SELECT * FROM WEBSITE WHERE website_id = 1 the output is: -------------------------------------------------------------------------------------- Seq Scan on website (cost=0.00..1.31 rows=1 width=162) (actual time=0.047..0.051 rows=1 loops=1) Filter: (website_id = 1) Total runtime: 0.102 ms --------------------------------------------------------------------------------------- Wondering why it is not using the index, which would have been automatically created for the primary key. Needing help. thanks Sanjay
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
