How to decide which type of index to create on a table ?

Showing Answers 1 - 1 of 1 Answers

kamlesh mishra

  • May 18th, 2015
 

Default type of index is B-Tree - usually created when the column have more distinct or unique values like emp_no.
When column have sequential values e.g 111,112,113,114 then use reverse key index
when you have used any functions within where clause, then use functional index
When a column having low distinct values or cardinality values like gender column, which can be male and female, or course column for student which could be matric, isc,graduation, pg etc. you should go for bitmap index.

Code
  1. CREATE <index_type> <index_name>  ON  <table_name> (column_name)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions