Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions

This is ONE TIME OFFER

bundle

50%

Enter your email address to receive your 50% off dicount code:

A confirmation link will be sent to this email address to verify your login.

* We value your privacy. We will not rent or sell your email address.

SPECIAL OFFER: GET 50% OFF

bundle

50%

Use Discount Code:

BRIEF50

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from support@prepaway.com and follow the directions.

IBM Exam Questions

Free IBM Study Guide

Skip to top navigation

eMail
Facebook
Twitter

Skip to main navigation

Log in

Skip to content

Menu

Home
Community
- Support & Feedback
- Discussion
Support
Change Logs
Register
Login

Search for:

You are here: Home > IBM Exam Questions > 000-540 > What can be done to make this faster?

Post navigation

Next question →

PrepAway - Latest Free Exam Questions & Answers

What can be done to make this faster?

seenagapeMarch 16, 2014

A SELECT statement spends all its time returning 1 billion rows. What can be done to make this
faster?

PrepAway - Latest Free Exam Questions & Answers

A.
“Use a CURSOR.

B.
“Use an EXTERNAL table.

C.
“Use the COPY command.

D.
“Increase the PreFetch Count.

Explanation:

In 000-540Exam 000-540

Post navigation

Next question →

One Comment on “What can be done to make this faster?”

Ravi says:

March 11, 2017 at 8:14 am

B

Thanks,
Ravi
IBM Netezza 7.1 certified
http://www.etraining.guru

0

0

Log in to Reply

Leave a Reply Cancel reply

You must be logged in to post a comment.

Hide Sidebar

Related questions

Recent comments

Ravi wrote A: Correct "For the administrator to receive the issued message, the RunAwayQuery event rule must be enabled." Ref: ...

Move Up

Home
About
Community
Privacy
TOS

The IBM Exam Questions are not in real test, just for reference.