Informix 12.10 Database Administration SPVC

Unit 1 - Creating databases and tables • Databases • Tables • DBSCHEMA, ONCHECK, and ONSTAT • Sysmaster Unit 2 - Altering and deleting databases and tables • ALTER • Data space reclamation • Renaming • Dropping Unit 3 - Creating, altering, and dropping indexes • Indexes • Sysmaster • Forest of trees Unit 4 - Managing and maintaining indexes • Benefits and costs • Guidelines • Calculating size Unit 5 - Table and index partitioning • Fragmentation • Distribution schemes • Sysmaster Unit 6 - Maintaining table and index partitioning • ALTER FRAGMENT Unit 7 - Cost-based query optimizer • Access plan • Join methods • EXPLAIN • Scans Unit 8 - Updating statistics and data distributions • UPDATE STATISTICS • Distribution information • Process • Updating statistics Unit 9 - Managing the optimizer • Optimization options • Directives Unit 10 - Referential and entity integrity • Integrity • Constraints Unit 11 - Managing constraints • Transaction modes • Dropping a constraint Unit 12 - Modes and violations detection • Object modes • Disabling an object • Recording violations • Sysmaster Unit 13 - Concurrency control • Isolation • Locks • Row versioning Unit 14 - Data security • Levels of data security • Privileges • Roles Unit 15 - Views • Working with views • WITH CHECK OPTION • Sysmaster Unit 16 - Introduction to stored procedures • Stored procedures • Sysmaster Unit 17 - Triggers • Working with triggers • Triggers and stored procedures • Dropping a trigger • Cursors and triggers • Triggers and constraint checking • Sysmaster • Managing triggers Appendix A - Terminology • Terminology Appendix B - Data types • Data types Appendix C - XML publishing • XML publishing Appendix D - Basic Text Search DataBlade Module • BTS DataBlade Module Appendix E - Node DataBlade Module • Node DataBlade Module Appendix F - Using Global Language Support • Using GLS