2013
DOI: 10.1007/978-1-4302-4810-1
|View full text |Cite
|
Sign up to set email alerts
|

Oracle SQL Tuning with Oracle SQLTXPLAIN

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...
1

Citation Types

0
1
0

Year Published

2015
2015
2015
2015

Publication Types

Select...
1

Relationship

0
1

Authors

Journals

citations
Cited by 1 publication
(1 citation statement)
references
References 0 publications
0
1
0
Order By: Relevance
“…Timing and indexed data columns are the important factors affecting the index's reasonableness. Height of almost all the B-tree indexes is 2 or 3, so to find a key in the index usually takes only two or three times I /O [1]. The one kind of index scan mode which has pertinence includes index uniqueness scan, index range scan, index full scan and index fast full scan [2], so you can choose different indexes timing depending on the various situations [3].…”
Section: Prefacementioning
confidence: 99%
“…Timing and indexed data columns are the important factors affecting the index's reasonableness. Height of almost all the B-tree indexes is 2 or 3, so to find a key in the index usually takes only two or three times I /O [1]. The one kind of index scan mode which has pertinence includes index uniqueness scan, index range scan, index full scan and index fast full scan [2], so you can choose different indexes timing depending on the various situations [3].…”
Section: Prefacementioning
confidence: 99%