• Index page
  • Información de interés
  • Login
  • Communities & Collections
  • Language
    Englishespañolportuguês (Brasil)
View Item 
  •   Redicuc Home
  • Producción científica y académica
  • Artículos científicos
  • View Item
  •   Redicuc Home
  • Producción científica y académica
  • Artículos científicos
  • View Item
Universidad de la Costa, CUC. Calle 58 # 55 - 66. Barranquilla, Colombia. 336 22 00. repositorioredicuc@cuc.edu.co. Corporación Universidad de la Costa.

Database performance tuning and query optimization

Thumbnail
View/Open
Database performance tuning and query optimization.pdf (174.1Kb)
Date
2018
Author
J. Kamatkar, Sadhana
Kamble, Ajit
Viloria Silva, Amelec Jesus
Hernández Fernández, Lissette
Garcia Cali, Ernesto Rafael
Metadata
Show full item record
BASE GoogleScholar
Compartir:


Impacto

URI: http://hdl.handle.net/11323/1616

Abstract

Today, IT professionals are challenged with the task of ongoing improvements to achieve goals of businesses. Unfortunately, some factor/Resources, skill environment does not dynamically grow as fast as business needs. That sequence of events creates major obstacles for DB infrastructure, deployment, administration and maintenance. This paper discusses the performance issues, different bottlenecks such as CPU bottlenecks, Memory structures, Input output capacity issue, Database Design issues and Indexing issues. Also this paper address Tuning stages and how SQL queries can be optimized for better performance. In this paper we are focusing on query tuning tips & tricks which can be applied to gain immediate performance gain by creating Query Execution Flow Chart. We demonstrate the application of this technique in an Employee Biometric Attendance Management System.
Collections
  • Artículos científicos

Browse

All of RedicucCommunities & CollectionsBy Issue DateAuthorsTitlesSubjectsThis CollectionBy Issue DateAuthorsTitlesSubjects

My Account

Login

Compartir en

Universidad de la Costa, CUC

  • Calle 58 # 55 - 66. Barranquilla, Colombia

  • 336 22 00

  • repositorioredicuc@cuc.edu.co

Corporación Universidad de la Costa CUC, Personería Jurídica con Resolución No. 352 del 23 de abril de 1971 y reconocida como Universidad mediante resolución 3235 del 28 de marzo de 2012 expedida por el MEN. Institución de Educación Superior sujeta a inspección y vigilancia por el Ministerio de Educación Nacional.

Enlaces institucionales:

  • Universidad de la Costa
  • Biblioteca
  • Catálogo bibliográfico
  • Recuperador Primo

Universidad de la Costa CUC.
Politica de Protección de Datos.