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

Saved in:
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!
Abstract <![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 Number of Iterations OR and IN without the Index Hint Limitation on the Number of Literal Values and the Size of OR Statement Dealing with More Than 1000 Literal Values for an IN Based SQL Query A Recommendation for Dealing with 1000 Literal Value Limit in an IN Statement Summary Recommended Reading Exercises ]]>
AbstractList <![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 Number of Iterations OR and IN without the Index Hint Limitation on the Number of Literal Values and the Size of OR Statement Dealing with More Than 1000 Literal Values for an IN Based SQL Query A Recommendation for Dealing with 1000 Literal Value Limit in an IN Statement Summary Recommended Reading Exercises ]]>
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 Number of Iterations OR and IN without the Index Hint Limitation on the Number of Literal Values and the Size of OR Statement Dealing with More Than 1000 Literal Values for an IN Based SQL Query A Recommendation for Dealing with 1000 Literal Value Limit in an IN Statement Summary Recommended Reading Exercises
Author Liu, Henry H
Author_xml – sequence: 1
  givenname: Henry H
  surname: Liu
  fullname: Liu, Henry H
BookMark eNpt0MFOAjEQBuAaNVGQB9BTXwDsdLfdlpsSRRIiUVavTbud6uq6SyjE4NMLAgeNPUwnk_nm8LfIUd3USMgFsB4wxi91pgBAQSJEwnvFK-cHpLWfAD8knd0GE1JrdUI6Mb6x9RNCcMFOyfXARqTTxdKv-nT6MKb5si7rlz4d3dNnnMdlpJPHfTesGmcrmuPHrJnb-Yrm1lV4Ro6DrSJ2dn-bPN3e5IO77ngyHA2uxt0SGIRukSaBA7c8tV57nVoE7Sym6HWmtQsug4LbUHimlBReCiUK56WVISuAM520SW9797OscGXQNc17NL8SMF_lzGxSMDMf1iD5BwAzm-j-wB-0KWt1vlUlIpqtyVgqJVPJN2EPaQI
ContentType Book Chapter
Copyright 2012 Wiley-IEEE Computer Society Pr
Copyright © 2012 John Wiley & Sons, Inc.
Copyright_xml – notice: 2012 Wiley-IEEE Computer Society Pr
– notice: Copyright © 2012 John Wiley & Sons, Inc.
DOI 10.1002/9781118135532.ch22
DatabaseTitleList

DeliveryMethod fulltext_linktorsrc
Discipline Computer Science
EISBN 1118135512
9781118135532
9781118135518
1118135539
1118135490
9781118135495
Edition 1
EndPage 503
ExternalDocumentID 10.1002/9781118135532.ch22
7046608
Genre chapter
GroupedDBID 089
20A
38.
3XM
5VX
6TE
92K
A4J
AABBV
AARDG
ABARN
ABIAV
ABQPQ
ABQPW
ACLGV
ADVEM
AERYV
AFOJC
AJFER
AJHQL
ALMA_UNASSIGNED_HOLDINGS
ALTAS
AZZ
BBABE
BEFXN
BFFAM
BGNUA
BKEBE
BNKTO
BPBUR
BPEOZ
COQFP
CZZ
ECNEQ
GEOUK
GL1
HF4
IFKZM
IPJKO
JFSCD
LQKAK
LWYJN
MYL
OCL
PLCCB
PQEST
PQQKQ
PQUKI
UZ6
V1R
W1A
YPLAZ
YSPEL
ZEEST
ABAZT
ACBYE
ACCPI
ACNAM
AHWGJ
AMYDA
WIIVT
ID FETCH-LOGICAL-i101f-c43f212a24ad9d94ae19bae4ed9799bfb71c2afcd08865d6585cbd6a6f7c12093
ISBN 9781118056998
111805699X
IngestDate Sat Nov 15 22:26:26 EST 2025
Wed Nov 27 04:58:15 EST 2019
Fri Nov 11 10:37:47 EST 2022
IsPeerReviewed false
IsScholarly false
Keywords Context
Java
Encoding
Indexes
Servers
Tuning
Language English
LinkModel OpenURL
MergedId FETCHMERGED-LOGICAL-i101f-c43f212a24ad9d94ae19bae4ed9799bfb71c2afcd08865d6585cbd6a6f7c12093
PageCount 12
ParticipantIDs wiley_ebooks_10_1002_9781118135532_ch22_ch22
ieee_books_7046608
PublicationCentury 2000
PublicationDate 2011
2011-11-04
PublicationDateYYYYMMDD 2011-01-01
2011-11-04
PublicationDate_xml – year: 2011
  text: 2011
PublicationDecade 2010
PublicationPlace Hoboken, NJ, USA
PublicationPlace_xml – name: Hoboken, NJ, USA
PublicationSeriesTitle Quantitative Software Engineering Series
PublicationSubtitle A Quantitative Approach
PublicationTitle Oracle Database Performance and Scalability
PublicationYear 2011
Publisher Wiley
John Wiley & Sons, Inc
Publisher_xml – name: Wiley
– name: John Wiley & Sons, Inc
SSID ssj0000555250
Score 1.3858865
Snippet <![CDATA[ This chapter contains sections titled: Context Test Program Observation 1: IN_CreateStatement is the Best Performer Observation 2: Batch Insert Saves...
This chapter contains sections titled: Context Test Program Observation 1: IN_CreateStatement is the Best Performer Observation 2: Batch Insert Saves Time...
SourceID wiley
ieee
SourceType Enrichment Source
Publisher
StartPage 492
SubjectTerms APPEND hint effects
SQL tuning, “IN” versus “OR”
test program
Title Case Study: SQL Tuning: IN Versus OR Versus Global Temporary Table
URI http://ieeexplore.ieee.org/xpl/articleDetails.jsp?reload=true&arnumber=7046608
https://onlinelibrary.wiley.com/doi/abs/10.1002/9781118135532.ch22
Volume 12
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV1LT-MwELZ4HRAHXruiy0M-rLSHkl3ydMIRxEugFmiQuEWOHYteQtW0uyy_nhnbSQlw4cDFsiwnjvxZ4_HE3zeE_FQh94TwAsflse8EAs4pPDzwHRkpznw_iZWUOtkE6_Xi-_vk2mZxrHQ6AVaW8dNTMvpSqKENwEbq7Cfgbl4KDVAH0KEE2KF84xG3Y682ARuHdQBYTjjuT3jBvcULGAAkRpm7CaVfDadm_ynH_2uqQq1cUJmLhloVanBz1U2npSVIX_S6GGqbVt3-bV0z-QO6aaN2lSIvy9gt1FOuULGj1Kw2vK80gB3gH148e6WJiLarvtYoZ8HVVixCG7LWAdVFhbkwSkym6cbieh8abyMGa59ywRHyvd_iwdCW34hiMzjWR8jxnmcMrNvi2Un_7rKJraGIGbh2OjGUHd-KLc2-xxKoYMw_70e0qXbaBxbtcaRrZAVZKBTpIfBF62SuKDfIap2Dg1qTvEmOECSqQTqkABE1EB3Six41sND-bV0zANEGIKoB-kbuTk_S43PH5sVwhmBAlSMCX4HHwb2Ay0QmAS_cJOdFUEj8R5urnLnC40pI2EGiUIKPGYpcRjxSTCBV2v9OFsrHstgiVIaxPMjRDc9RpSiOMWFrzIUMQlm4IeuQdZyIDBd0ldlZ75B9PS1ZYZqN8rWXteYxw3nURYf8anVvd3sejkzXkVQ_PhptmyzPltoOWZiMp8UuWRJ_J8NqvGehfwE1-lgu
linkProvider ProQuest Ebooks
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=bookitem&rft.title=Oracle+Database+Performance+and+Scalability&rft.au=Liu%2C+Henry+H&rft.atitle=Case+Study%3A+SQL+Tuning%3A+IN+Versus+OR+Versus+Global+Temporary+Table&rft.series=Quantitative+Software+Engineering+Series&rft.date=2011-01-01&rft.pub=Wiley&rft.isbn=9781118056998&rft.volume=12&rft_id=info:doi/10.1002%2F9781118135532.ch22&rft.externalDocID=7046608
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=9781118056998/lc.gif&client=summon&freeimage=true
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=9781118056998/mc.gif&client=summon&freeimage=true
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=9781118056998/sc.gif&client=summon&freeimage=true