Write various indexes used in Cognos?

devquora
devquora

Posted On: Feb 22, 2018

 

There are many types of indexes used in Cognos. These are:

  • Bitmap Indexes: A bitmap index is used to replace a list of rowids with the key values. Due to the presence of low cardinality and low updates, it is more efficient for data waring.
  • B-tree indexes: B-tree indexes are used on the availability of high-cardinality, generally when we have too many distinct columns. It is mainly used for OLTP.
  • Function-based indexes: These are created on the results of an expression or function.
  • Reverse key and Composite Indexes: In the reverse key, the keys of an index are reversed and then stored.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Cognos Interview Questions

    What do you understand by the Cognos?

    Cognos was an Ottawa company which is based on Ontario performance management software...

    Cognos Interview Questions

    What are the advantages of Cognos?

    It has many advantages that are described below:..

    Cognos Interview Questions

    What do you understand by the term 'Dynamic Cube'?

    Dynamic cubes are present in-memory Online Analytical Program (OLAP) which loads data from the relational data source...