.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

Performance wise which one is the best? IN,EXISTS or INNER JOIN

Posted By :Sajid P K     Posted Date :November 25, 2010    Points :10   Category :Sql Server 
It depends.

Generally speaking JOINs are much better than EXISTS & EXISTS is better than IN, performance wise.

If your result set is small then you can use IN or EXISTS.

But if result set contains a large set of records, then use JOINS.

You can also find related Interview Question to Performance wise which one is the best? IN,EXISTS or INNER JOIN  below: 

What is Thread.Join() in threading ?

There are two versions of Thread.Join :-
. Thread.join().
. Thread.join(Integer) this returns a Boolean value.
The Thread.Join method is useful for determining if a thread has completed before starting another task. The Join method waits a specified amount of time for a thread to end. If the thread ends before the time-out, Join returns true; otherwise it returns False. Once you call Join, the calling procedure stops and waits for the thread to signal that it is done.
Example you have "Thread1" and "Thread2" and while executing 'Thread1" you call "Thread2.Join()".So "Thread1" will wait until "Thread2" has completed its execution and the again invoke "Thread1".
Thread.Join(Integer) ensures that threads do not wait for a long time. If it exceeds a specific time which is provided in integer the waiting thread will start. (More...)

How do I invite users to join a Windows SharePoint Services Site? Is the site secure?

SharePoint-based Web sites can be password-protected to restrict access to registered users, who are invited to join via e-mail. In addition, the site administrator can restrict certain members' roles by assigning different permission levels to view post and edit. (More...)

What is a Join in SQL Server?

Join puts data from two or more tables into a single result set. (More...)

What are the factors that affect the performance of NIC?

The following factors affect the performance of NIC,

Bus Speed :- It depends on ISA or PCI slot. PCI has higher speed.

Memory :- More the memory, better the performance.

Memory Access Method :- DMA is faster than I/O method. (More...)

To find a particular column name where it exists in a database?

The Query to find the particular column name in a databse is,


How do we join the values in an array?

Using the method Join() as follows.

var arr = new Array();
arr = ["one","two","three","four"];
alert(arr.join(",")); (More...)

ATM - Performance ?

1. Throughput - Rate at which ATM cells depart from the ATM switch.

2.Connection Blocking Probability - Defines the probability of Non-availability of enough resources for generating physical
connections between inlet and outlet .

3. Cell Loss Probability - Defines a no. of data cell that can be handled by a switch queue.

4. Switching Delay - Time required for cell to pass through the ATM switch.

5. Cell Delay Variation - Probability that the switching delay of the ATM switch exceeds the certain value . (More...)

How do you improve the performance of a server?

First check the processor and memory usage to see that processor is not above 80% utilization and memory not above 40-45% utilization then check the disk utilization using Performance Monitor, Secondly, use SQL Profiler to check for the users and current SQL activities and jobs running which might be a problem. Third would be to run UPDATE_STATISTICS command to update the indexes (More...)

what is left outer join?


Matched records from the tables and unmatched records from left table. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend