HI,
Recently I had a requirement to add a field to a standard table and add it to the primary key of the table.
I see that in most of the tables there are multiple indexes however the ones used for primary index is offcourse only one.
The question over here is that why do we have so many indexes when we are going to use only the primary index Does the use of the indexes is only to fetch the records faster based on index ?
Also in case there is a requirement to modify a primary index of a std table then how can we achieve the same?
Thanks,
K
