首页    期刊浏览 2024年11月28日 星期四
登录注册

文章基本信息

  • 标题:An Empirical Evaluation of LIKE Operator in Oracle
  • 本地全文:下载
  • 作者:Manoj Kumar Gupta ; Pravin Chandra
  • 期刊名称:BVICAM's International Journal of Information Technology
  • 印刷版ISSN:0973-5658
  • 出版年度:2011
  • 卷号:3
  • 期号:2
  • 出版社:Bharati Vidyapeeth's Institute of Computer Applications and Management
  • 摘要:In database systems, user makes query and that query will be responded by the DBMS. Generally, there are a variety of methods for computing the response of the given query. It is the responsibility of the query processor to transform the query as entered by the user into an equivalent query that can be computed more efficiently. Query optimization is the process to find a good strategy or best query evaluation plan for processing a query. In the today’s competitive environment, query optimization is one of the important criteria based on which one can compare the available commercial RDBMSs. The objective of this study is to discuss about techniques used by the Oracle for optimizing the queries and to present a comparative study of the various costs involve to execute the LIKE Operator based queries. This comparative study is based on empirical study done on Oracle 8i, Oracle 9i and Oracle 10g. ove
  • 关键词:Query Optimization; Oracle; Cost Control; LIKE Operator; Pattern Matching in DBMShods GA
国家哲学社会科学文献中心版权所有