Buy Questpond's video subscriptions on
huge discount
.
Online: 2115
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
You are optimizing several complex queries. You have determined that you can improve performance by hashing UNION sets.
Which of the following query hints should you use to implement this optimization?
Posted by
Rajkatie
on 6/30/2013 | Category:
Sql Server Interview questions
| Views: 23377 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
HASH UNION
HASH JOIN
MERGE UNION
All Above
HASH UNION query hint option specifies that all UNION operations will be performed by hashing UNION sets.
Show Correct Answer
Source:
measureup.com | |
Alert Moderator
Bookmark It
< Previous :
You are optimizing several complex queries. You ha ...
Next > :
You are optimizing several complex queries. You ha ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
You are optimizing several complex queries. You have determined that y ...
You have noticed that a particular block of Transact-SQL code triggers ...
An error occurs when you execute a block of Transact-SQL code, causing ...
You are working with some T-SQL code that causes an error. You want to ...
An error occurs when you execute a block of T-SQL code, causing a tran ...
An error occurs when you execute a T-SQL code. You configure the appro ...
You want to find out the specific line in a block of T-SQL code that c ...
You want to ensure that statements in the transaction can read rows al ...
Latest Interview Questions
In.Net which is the parent class to create all windows service?
What is infonomics?
how to change the database owner?
What is the maximum size of columns in a particular table?
How to convert server name to host name?
How can you detect the servername ?
How can you detect the host name and Ip address?
How can you detect the version properties?
More ...
Show Correct Answer