Thread: SQL Interview question

Hello,

It is Interview Quetion,I am joing 5 tables,if query is too long,what i have to do,what are the other option?

we can use subquerys...insted of using more joins....

Originally Posted by nithya R

Hello,

It is Interview Quetion,I am joing 5 tables,if query is too long,what i have to do,what are the other option?

u can use subquerys .insted of joins....for better performance...

Is this question in reference to LINQ or SQL Server?

Try creating indexes.

Hi,
If you know the structures of all tables You will be having more chances of doing this type of quires in different ways.
for ex: If ur having related columns in each and every table use natural join( or self) (this will go better when the records were few, if the entities are huge it will take time to execute) ,
or
Group the entities according to their related columns and join them,
if you are feeling tough doing all this you are having the only way that is using sub quires
or
creating Indexes to improve performance that will help you to use joins.
bye sudheer

How to how many cursors are opened when we are running an oracle function or procedure?