Chapter Summary

This chapter introduced you to using DDL statements for creating indexes. Columns that are frequently used in database queries should be indexed to allow for faster access to the information. However, if you frequently add, delete, and update rows, you might want to limit the number of indexes, as they take up disk space and slow data operations. You also learned that a primary key is a special type of index that allows you to uniquely identify rows in a table as well as create a relationship between two tables, as demonstrated in the previous chapter.

The next chapter shows you a number of DDL statements that are used to manage database security.

0 0

Post a comment