SQL Indexing technology sharing - content Planning
ORACLE Execution Technology
1) What is the implementation plan?
2) How does the execution plan analyze the best path?
3) use PL/SQL to demonstrate how to view the execution plan?
4) Benefits of the implementation plan
What is an index?
1) concept of index
2) Index related concepts, such as rowID, node graph, etc.
3) How do I create an index? Create an instance of an index
4) How do I modify an index?
5) How do I delete an index?
6) Advantages and disadvantages of indexes
7) scenarios where the index should be created
8) scenarios where indexing should not be created
9) restricting indexes
-- Some improper use of indexes, such as using unequal operators,is NULL, was NOT NULL, function, etc.
Classification of indexes
1) According to the way index is organized
(1) B- tree index
(2) bitmap Indexing
(3) HASH Index
2) According to the relationship between Index and table
(1) clustered index
(2) non-clustered index
B- Index
1) B- tree index structure and included components
2) B- tree index for insertion (insert) management
3) B- tree index for deletion (delete) management
4) B-Tree indexmanagement of updates (update)
5) b -Tree index features
Bitmap index
1) bitmap index structure
2) Bitmap Index to add, delete, the management
HASH Index
1) HASH index structure
2) HASH Index to increase, delete, the management
Clustered Index and non-clustered indexes
1) What are clustered and non-clustered indexes?
2) The difference between the two
Oracle Execution Plan and indexing Learning Plan