All Forums Tools
hisabuz 2 posts Joined 09/13
04 Nov 2013
Secondary index

Hello everybody, I am very new to Teradata.Can anyone pls explain me in brief, in which situation we use Secondary index and why.
I really appreciate that.

M.Saeed Khurram 544 posts Joined 09/12
05 Nov 2013

Hi,
You can use the secondary indexes in the following situations:

  1. To improve access of frequently accessed columns which can not be defined as PI.
  2. To enforce uniqueness using USI  (PrimaryKey, UNIQUE)
  3. To improve access to Range queries(NUSI over PPI tables)

But remember Secondary indexes cause a lot of overhead on system resources in terms of Disk space and IO. SI create a subtale that use diskspace and there is a maintainance overhead as well.
 

Khurram

hisabuz 2 posts Joined 09/13
06 Nov 2013

Thanks a lot Mr. Saeed, its helped me a lot. I appreciate your help. 

You must sign in to leave a comment.