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.
You can use the secondary indexes in the following situations:
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.