Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Are you sure you have quoted the interview question correctly?
2. I am having a lot of indexes in my pgm and the performance has been reduced due these indexes .
i..e of which sql statement?
Programs do not "have indexes"; tables have indexes. If you have a performance issue due to indexes it may be the insert/delete (or certain types of select) that are affected. Insert and delete must create and remove all of the index entries for that row.