rajemessage 14195 (6/18/2014)
questions are inside Q1)Q2)Q3)yours sincerley
Without some details there is no chance anybody can offer much here. We can't see your screen, we have no idea what your tables and index definitions are like. All we have is some pseudocode. I assume when you say "bigger" and "smaller" you are referring to the number of rows in the tables?
I still don't see any actual question in here. You have some interesting theoretical discussions but no actual question.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/