Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Procesamiento Optimización Consultas - IS163 (7)

No description
by

Antonio Ayala

on 19 March 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Procesamiento Optimización Consultas - IS163 (7)

Obstacle 1 Obstacle 2 Obstacle 3 Goal Start Conocer:
+ Detalle del Ambiente
+ Aplicaciones : tipo y frecuencia
+ Indicadores de Rendimiento
Análisis de Consultas y Transacciones
Análisis de Índices
Objetivos de Optimización Ajuste de Consultas Consultas ajustadas
Índices actualizados
Mantenimiento realizado y programado
Procesamiento
Optimización CONSULTAS SQL Entender Procesamiento SQL Evaluación Regla de 80 / 20
Cumplimiento de Objetivos

Ajuste en base a :
+ Recomendación de especialistas
+ Experiencia
+ Pruebas! ¿Que? Plan de Consulta/Ejecución
Primer trabajo del Optimizador de BD ¿Como? ¿Hasta Cuando?
Full transcript