Unix Technical Forum

Add Constraint

This is a discussion on Add Constraint within the Informix forums, part of the Database Server Software category; --> I've just added a constraint on a table both the master and detail tables have over 100M rows, and ...


Go Back   Unix Technical Forum > Database Server Software > Informix

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 09:06 AM
Colin Dawson
 
Posts: n/a
Default Add Constraint


I've just added a constraint on a table both the master and detail tables
have over 100M rows, and it took almost 2 hours, does anyone know what
exactly happens during an ADD CONSTRAINT.




Regards

Colin

There are 10 types of people in the world, those that understand binary and
those that don't
sending to informix-list
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 09:06 AM
scottishpoet
 
Posts: n/a
Default Re: Add Constraint

maybe the database is building some indexes and checing there are no
violations?

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:23 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com