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...

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:Oracle Database Performance and Scalability Ročník 12; s. 492 - 503
Hlavní autor: Liu, Henry H
Médium: Kapitola
Jazyk:angličtina
Vydáno: Hoboken, NJ, USA Wiley 2011
John Wiley & Sons, Inc
Vydání:1
Edice:Quantitative Software Engineering Series
Témata:
APPEND hint effects
SQL tuning, “IN” versus “OR”
test program
Context
Java
Encoding
Indexes
Servers
Tuning
ISBN:9781118056998, 111805699X
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
Popis
Shrnutí:<![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 ]]>
ISBN:9781118056998
111805699X
DOI:10.1002/9781118135532.ch22