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.