IntraDoc development
Agenda
Goals
Methods
Model
Database server
Oracle optimizer
Installation
Keep data clean
How to avoid NULL
Efficient Queries I
Efficient Queries II
Using indexes
Check the index
How to kill an index - I
How to kill an index - II
How to kill an index - III
Access Path I
Access Path II
Measuring performance
Demonstration
Using SQL navigator
Checking the plan
Study plan
TKPROF and trace
Creating trace file
Running TKPROF
Analyzing result I
Analyzing result II
Obervations
Check Oracle
Author: Ottar Kvindesland
E-mail: ottar.kvindesland@projects.no
Best viewed with
