Your indexes must be pretty unique as they are the same size as your table. Are the first few columns in the index repeatable? Did you try it out on a subset of data? Mike -- //www.freelists.org/webpage/oracle-l