tailieunhanh - creating indexes

If you want to improve the performance of some queries, you should consider creating an index. You can also use indexes to enforce uniqueness on a column or a collection of columns. At the end of this lesson, you should be able to Distinguish between the indexes that are created automatically and those that are created manually. Identify the uses for indexes. Explain the index structure and why it improves query speed. Create a non-unique index. Remove an index from the data dictionary. Evaluate guidelines for creating and using indexes | 15 Creating Indexes ORACLG Objectives Distinguish between the indexes that are created automatically and those that are created manually. Identify the uses for indexes. Explain the index structure and why it improves query speed. Create a non-unique index. Remove an index from the data dictionary. Evaluate guidelines for creating and using indexes. Schedule Timing 25 minutes 25 minutes 50 minutes Topic Lecture Practice Total Class Management Note Files required for this lesson are Demonstration None Practice None 15-2 Introduction to Oracle SQL and PL SQL Using Procedure Builder Objectives If you want to improve the performance of some queries you should consider creating an index. You can also use indexes to enforce uniqueness on a column or a collection of columns. At the end of this lesson you should be able to Distinguish between the indexes that are created automatically and those that are created manually. Identify the uses for indexes. Explain the index structure and why it improves query speed. Create a non-unique index. Remove an index from the data dictionary. Evaluate guidelines for creating and using indexes. Creating Indexes .