Tuning Overview List the roles associated with the database tuning process The DBA, the application developer, management, the system administrator, the network administrator. Define the steps associated with the tunning process Considered on the ROI (Return on Investment) outline here are the tunning recommendation in order: Do a proper logical design: In practice this often means more tables with fewer rows per table. In turn, this means the capability for faster searching. The fewer rows that are stored and must be searched through, regardless of the search techinque, the quicker you'll be able to find what you're looking for. Do a proper physical design : Separate the datafiles (tablespaces ) into different disks to avoid I/O contention , use striping. Redesign if necessary Sometimes the best way to correct the database without extensive tuning efforts is a re-analysis and redesign. Consider redesign when the initial design
"...NADA SE CREA NADA SE DESTRUYE, TODO SE TRANSFORMA..." Por Wilmerbarriosjr