I have two tables A and B where A is a huge table with thousands of rows, B
is a small table with only a couple of entries.
I want to do something like
A JOIN B ON (A.ID = B.ID)
And on the other hand I can have something like this
A.ID IN (B_Id_List)
B_Id_List is a string concatenation of B.ID. (ie, 1,2,3,4,5 ...)
Which one is faster, more efficient?
And if you could, which one is faster/more efficient under MS SQL Server 7?
I am trying to develop a cross platform query, that is why I need to
concern with performance under different databases.
Thanks a lot!
In response to
pgsql-performance by date
|Next:||From: Ron Johnson||Date: 2002-12-11 05:46:04|
|Subject: Re: Which of the solution is better?|
|Previous:||From: Ron Johnson||Date: 2002-12-10 23:13:35|
|Subject: Re: questions about disk configurations|