Lets try it !


This page demonstrates creation of indexes on the third fact table and dimension table to improve query processing by reducing the need for full table scans and repeated sorting of data for queries.

Operation


  1. Create fact table 'subscriber_msisdn_history_ind' and dimension table 'dedicated_account_ind'
  2. Create a regular index on the 'subscriber_msisdn' column as it is used in the join between tables


Best Practices


  1. Index every Primary Key (PK) and most Foreign Keys (FK) in a database. Most joins occur between PKs and FKs
  2. Columns frequently referenced in WHERE clauses are good candidates for an index. An exception to this rule is when the predicate provides minimal filtering (for eg. inequalities)
  3. Specify indexes on columns used for equality and range queries
  4. Add indexes only when absolutely necessary. Remember that indexes significantly impact INSERT, UPDATE, and DELETE performance, and they also require storage
  5. Examine queries with range or with ORDER BY clauses to identify clustering dimensions
  6. Avoid or remove redundant indexes