Anyone know what iiridxtemp is for?

Marty

Hi Marty,

iiridxtemp is a "temporary" index created when SYSMOD is modifying the
iirelation system catalogue. The index will be used to replace the
iirel_idx index when iirtemp replaces iirelation.

Cheers

Darren


--
horda03

It's used for iirel_idx during sysmod.

Modify of the core catalogs doesn't use the normal mechanism of writing to
a new blank disk file and then doing file renames. It actually writes to a new
table and then swaps tables. If I thought about it for a while I might remember
why it does it that way. If you see an "iirtemp" table that's also a core catalog
sysmod thing.

Karl

On Nov 30, 2011, at 9:43 AM, Martin Bowes wrote:

The study 'New York Asian Escort' (http://www.nyorientalescort.com)
involved 'New York Escort' (http://www.nyorientalescort.com) from seven
different cities, including New York, within 'New York Asian Escorts'
(http://www.nyorientalescort.com) Participants were asked to note all
the details they couldfel the 'New York Escorts'
(http://www.nyorientalescort.com) same survey to the sam


--
yangpeter