Re-creating indexes without losing statistics updates

To drop and re-create an index after you have updated a histogram, and you want to keep the edited values, specify 0 for the number of steps in the create index command. This command re-creates the index without changing the histogram:

create index title_id_ix on titles(title_id)
with statistics using 0 values