Could I get some stats on the max time some of you took to rebuild a join form (after modifying the join criteria from the Remedy application level) between tables that have a record count of about 200K to 300K...
What I want to know is after you save the join, how much time does it take to rebuild the join view internally in the DB.. is it instantanous? Or does it take a while during which time it might appear that records that were existing in the join are no longer in it and then when the join built is complete you get to see the 'missing' records?
This may be a stupid question.. I am having a long day so for some reason I'm begining to doubt some of my knowledge on a couple of basics of table join.. I know this stuff takes time, but just wanted to reconfirm..
Rgds
Joe.
__20060125_______________________This posting was submitted with HTML in it___
