Research on SQL Paging Query Tuning Based on ROWID in ORACLE Data Base

来源 :第四届信息电子与计算机工程国际会议(The 4th International Conference on Inform | 被引量 : 0次 | 上传用户:mmmmmmmmmmmmmmmmmmmm
下载到本地 , 更方便阅读
声明 : 本文档内容版权归属内容提供方 , 如果您对本文有版权争议 , 可与客服联系进行内容授权或下架
论文部分内容阅读
  In database application, the times that ordering and paging the result selected according users demand is great.At first, this pager shows the ROWID in Oracle database and the relationship between ROWID and B-tree.Then, it shows the functionality of ROWNUM.At last, it shows the difference between the conventional paging method and the new paging method take use of ROWID, and makes contrast with two methods on execution cost.
其他文献
本文对智能家居网络中的应用进行分析,阐述智能家庭网络组建过程中的主要技术要点,该系统以家居服务器为核心,利用网络接口接入Internet和有线电视网,利用IEEE1394高速数据总线连接数字音像设备、利用蓝牙连接各种信息家电,利用无线编码通信收发各种传感器信号,通过家居服务器内的网关转换各种协议并且沟通联系。家居服务器保存数据信息,提供家电的本地服务支持,实现家居控制、管理和网络浏览等功能。
Neighborhood Preserving Embedding (NPE) is a linear algorithm which can preserve the local geometric structure information of data after mapping however, as an unsupervised algorithm, the extracted fe
Using the open network structure and comprehensive access ability of the Soft-switch network, we can build a railway special communication system.In this system, the built-in system of the railway spe
Internet marketing has become the important means by which enterprise achieves its management goal, Internet marketing performance assessment has been brought to more and more enterprises concern and
光学导引头捷联稳定平台的重要技术之一,是在有噪声的角位置传感器信号中获得较真实的角位置或角速率,减小平台零位漂移,实现平台在惯性空间的精确定位;应用具有统计滤波原理的α-β-γ递推式数字滤波器并结合高采样率下滤波与微分特点,对其传递函数特征点的频率特性、测量噪声误差、模型截断误差和跟踪瞬态响应误差进行研究;结果表明:在捷联平台稳定环截止频率45rad/s处,采样时间为0.08ms时,在最大平台运动
Over the last decade, facial expression analysis has become an active research area which finds potential applications in fields such as more engaging human-computer interaction, multimedia informatio
By briefly summarizing the conservation phases of Daling village, this paper points out some problems in the conservation process, which are the conflict of conservation and development, the efficienc
With the continuous development of Internet technology, the website no longer just browse the information carrier, the viewer to members as the site of a role has become increasingly common phenomenon
The Web Services is based on a series of open standard technologies, with loose coupling, language-neutral, platform-independent and interoperability advantages.Each platform of Web Services to the WS
The paper chooses the soil in Qingyang city in China, and form Consolid solidfied soil by using Consolid stabilizer which includes stabilizer of water agent CONSOLID444 (C444) and power agent SOLIDRY