Skip to Main Content
SAS Data Integration Studio 4.9
book

SAS Data Integration Studio 4.9

by SAS Documentation
August 2014
Intermediate to advanced content levelIntermediate to advanced
808 pages
25h 30m
English
SAS Institute
Content preview from SAS Data Integration Studio 4.9
Using Properties Window Options to Optimize
SQL Processing Performance
Problem
You want to set specific options in the SQL Properties pane or table properties panes
that are located in the Designer window for an SQL Join transformation. These options
are intended to improve the performance of SQL processes that are included in a SAS
Data Integration Studio job.
Solution
Use one of the following techniques:
“Bulk Load Tables” on page 486
“Optimize the SELECT Statement” on page 487
“Set Buffering Options” on page 487
“Use Threaded Reads” on page 487
“Write User-Written Code” on page 488
Tasks
Bulk Load Tables
The fastest way to insert data into ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

A Gentle Introduction to Statistics Using SAS Studio in the Cloud

A Gentle Introduction to Statistics Using SAS Studio in the Cloud

Ron Cody

Publisher Resources

ISBN: 9781629593098