fetch first的意思
fetch first中文翻譯:
先提取
fetch rewards───獲取獎勵
fetch back───拿回來;取回
can fetch───可以提取
fetch into───進入
fetch api───獲取api
git fetch───git獲取
fetch app───獲取應用程序
fetch ruffman───去叫流氓來
fetch from───從…取出;把…從…接[取]來; 招來(某人), 引起
In essence, the OPEN positions into the index and the FETCH first will retrieve the first row based on the RRN provided by the index.───上,OPEN定位到索引中,FETCH FIRST將基于索引提供的rrn檢索第一行。
Listing 19 lists the plan showing the efficient use (FETCH (8)) of ORDER BY and FETCH FIRST 1 ROW ONLY discussed above.───清單19列出的計劃展示了使用前面討論的ORDER BY的(FETCH(8))和FETCH FIRST 1 ROW ONLY的效率。
The FETCH FIRST clause encourages sort avoidance.───FETCH FIRS t子句鼓勵規避排序。
The FETCH FIRST clause encourages sort avoidance.───FETCHFIRST子句鼓勵規避排序。
Without the FETCH FIRST (or similarly, but not exactly, without an OPTIMIZE FOR clause), then DB2 would almost certainly prefer some other access path.