Hi, I have created a table with 40 columns and secondary index on 35 of the columns individually.
Loaded around half million records. Data in all columns is smaller size. For a long time, the index had not been updated. It almost took overnight to catch up with all the records. Is this usual behavior if we have that many indexes? How to monitor how far behind those indexes are? Is there anyway to optimize it to reduce the lag time? Saurabh
