|
View previous topic :: View next topic
|
| Author |
Message |
mailsaurabh.tripathi
New User
Joined: 22 May 2008
Posts: 56
Location: hyderabad
|
|
|
|
| what does informational referential constraints mean! |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
| Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
|
|
|
|
Lets say we create a table
CREATE TABLE EMP (EMPID INT CHECK (EMPID > 1000) NOT ENFORCED
ENABLE QUERY OPTIMIZATION)
here the check constraint is an informational one ..its used to increase performance ...now if u insert a row with empid = 100 the insert will be successful but if u say SELECT * FROM EMP WHERE EMPID = 90 this will return none as u have already set an access path where empid > 1000 ...
its just like telling the optimizer that empid will always be greater than 1000 so dont chk for anything less than that ... |
|
| Back to top |
|
|
|
|
