Performance tuning

Database
Enthusiast

Performance tuning

Hi all

I would like to know what are all steps involved in performance tuning.
Can any one help.

Thanks
Madhavi
1 REPLY
Enthusiast

Re: Performance tuning

madhavi,
perfomance tuning is slightly a broader word to cover.but basic steps in TERADATA for perfomace tuning would be
creating correct P.I's
creating correct S.I's-and dropping it if the P.E does not use the created S.I
collecting stats on heavily used columns+Index(must) regularly
executing explain plans and verify that large table is not redistributed or Full Table Scan is not perfomed or product joins are not done.

Explain in teradata gives you a much information than any thing.

hope this helps