General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Binary index problem with a large cursor
Environment versions
Network:
Windows 2003 Server
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only