[EMAIL PROTECTED] writes:
Usage is to match data from the key and val tables to fetch the data
value from the sid table.
What is the relation between key and val tables?
Will key.id and val.id be equal?
I have never quite/fully understand the outputs of analyze, but I wonder why
you have:
-> Nested Loop (cost=0.00..4467.01 rows=1001 width=20) (actual
time=0.205..28.304 rows=1000 loops=1)
Why 1000 rows?
Does any of your conditions in the select returns many records?
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
