Hi,

For a typical data warehousing application having a few million records
what are the pros and cons of using index rebuild options v/s drop and re-create while inserting /updating recs in bulk

is the index rebuild option really faster in this case ?