Case Study: SQL Tuning: IN Versus OR Versus Global Temporary Table

<![CDATA[ This chapter contains sections titled: Context Test Program Observation 1: IN_CreateStatement is the Best Performer Observation 2: Batch Insert Saves Time Temptable Performed Better without an Index Hint than with an Index Hint Effects of APPEND Hint for Populating Temptable Effects of...

Full description

Bibliographic Details

Published in:	Oracle Database Performance and Scalability Vol. 12; pp. 492 - 503
Main Author:	Liu, Henry H
Format:	Book Chapter
Language:	English
Published:	Hoboken, NJ, USA Wiley 2011 John Wiley & Sons, Inc
Edition:	1
Series:	Quantitative Software Engineering Series
Subjects:	APPEND hint effects SQL tuning, “IN” versus “OR” test program Context Java Encoding Indexes Servers Tuning
ISBN:	9781118056998, 111805699X
Online Access:	Get full text
Tags:	Add Tag No Tags, Be the first to tag this record!