Skip site navigation (1) Skip section navigation (2)

Disadvantage of SQL Joins

From: Ranjan Kumar Baisak <rbaisak(at)nyc(dot)yamaha(dot)com>
To: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Disadvantage of SQL Joins
Date: 2006-11-29 15:38:32
Message-ID: 456DA978.2020407@nyc.yamaha.com (view raw or flat)
Thread:
Lists: pgsql-general
Can anybody please tell me whether there are any disadvantage of SQL 
joins in terms of space and time and how postgres has implemented SQL 
joins? I am in the impression that SQL join takes more time for 
execution as well as space because database internally builds Cartesian 
product and then evaluates for condition. Recently I normalized by DB 
and changed my application Data model which resulted in writing lots of 
inner join queries. Later I found that DB server is consuming more 
memory. And once my Database also crashed. I am assuming that because of 
normalization and inner joins, my DB crashed.
Can anybody please give a thought into my assumption?

- R

In response to

Responses

pgsql-general by date

Next:From: Michal Taborsky - Internet MallDate: 2006-11-29 15:47:49
Subject: LOCK ... NOWAIT throws error
Previous:From: Merlin MoncureDate: 2006-11-29 15:34:21
Subject: Re: backend crash following load command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group