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?
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....
u can use subquerys .insted of joins....for better performance...Originally Posted by nithya R
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?
How to write a function or procedure that verify the correct email id entered by the user??
Last edited by admin; 03-07-2008 at 07:28 AM.
Posting Permissions
Reply With Quote