Come to this lecture if you want to
learn:
-
what tuning is, why it's perceived as
magic and how to tame it,
-
when to start tuning a database
application,
-
what techniques and tools to use,
-
what is an SQL optimizer and how
to make it work better,
-
how to read an execution plan,
-
what types of indexes to use and why,
-
why timing and logging is so
important,
-
why avoid using optimizer hints
All
these issues are presented based on an Oracle database. But
they are also relevant to other database systems! |