Comparing

Hello All, Looks like emails to the ids group is not being delivered. I would like to know what would be the complications comparing Integer Vs Serial Datatype in a join. We have six such join condition and the table has over 10 million rows. The current query takes about 15 mins to run. If we compare Serial Vs Serial column will the query process faster. Thanks in advance. Lloyd

SERIAL is the same type as INT it just has the special property of generating the next number when zero is inserted and not permitting updates. Similarly SERIAL8 is the same type as INT8 and BIGSERIAL is the same type as BIGINT. There will be no difference in joins between using INT<-->SERIAL versus INT<-->INT BTW, your previous posts went through. Didn't think there were useful responses to your other posts. ;-( Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Jun 1, 2010 at 8:59 AM, LLOYD SERRAO <serrao.lloyd@gmail.com> wrote: > Hello All, > > Looks like emails to the ids group is not being delivered. > I would like to know what would be the complications comparing Integer Vs > Serial Datatype in a join. We have six such join condition and the table > has > over 10 million rows. The current query takes about 15 mins to run. If we > compare Serial Vs Serial column will the query process faster. > Thanks in advance. > > Lloyd > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636e1f81f9d24210487f90b2d