Posted by sjoshi on 03/01/06 04:28

There are no 7.5 million rows in a database. These rows get inserted
into the temporary table #SP3DCoreOID after it gets all the distinct
ones from all the CORE named tables. The stored procedure,
CORESetObjectIntegrity just inserts/updates a row in another table.
The oids are of type GUIDS.

thanks
Sunit

• Next in forum: ANN: 75% off on Database Workbench, only 3 days left!
• Prev in forum: Optimizing a JOIN
• Thread view: Re: How to avoid cursors

[Reply to this message]