[SQL] Query tuning

2008-05-14 Thread kapil.munish
Hi, I have a query which is run across 3 tables JOB_TYPE_FIRST, JOB_TYPE_SECOND and JOB_ALLOCATION_WORKLIST. The column JOBID is referenced in JOB_ALLOCATION_WORKLIST table and primary key in both JOB_TYPE_FIRST, JOB_TYPE_SECOND tables. There is one more column BOOK_ID which is supplied

Re: [SQL] Reg:-How to make relationship more one table in PgSQL

2008-04-29 Thread kapil.munish
Hi Venkat, What kind of relation you want to create? Is it to do with the creation of dependencies or something else? Regards, Kapil From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of venkat Sent: Tuesday, April 29, 2008 4:41 PM To: pgsql-sq