Performance Tuning (cont)
Performance can be considered at two times:
- during schema design
- typically towards the end of schema design process
- requires schema transformations such as denormalisation
- outside schema design
- typically after application has been deployed/used
- requires adding/modifying data structures such as indexes
Difficult to predict what query optimiser will do, so ...
- implement queries using methods which should be efficient
- observe execution behaviour and modify query accordingly
|
![[prev]](icon/prev.gif){kind=icon}
![[next]](icon/next.gif){kind=icon}