>I have a process that loads about 8 million rows of data from a csv file, massages the data, and subsequently inserts the data into a SQL server table. In an effort to improve performance, I changed an index tag that I build on DELETED() to binary.
>
>The entire process ordinarily takes around four hours from start to finish. I launched it last night around 6:30 PM (against a test server) and found that it was still attempting to build the indices (DELETED() Binary, a Varchar (25), and a couple of integer keys at 9:30 this morning. The cdx in the tmpfiles directory appeared to be a 0 byte file. If memory serves, the cdx is usually several hundred mb.
>
>Obviously, I will retain the regular index on DELETED(). Just wondered if anyone else has run into this.
Haven't experienced it, but it sounds like your index file may have crossed the 2GB file size limit. Maybe you can try creating the binary index into a separate .CDX file?