var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Information Constraint
I've created a table which implements Informational constraint as follows
create table tab1(SNum integer, Name char(30), constraint c1 check (Num > 10) no enforced enable query optimization)
(Not sure whether this implements informational constraint)
After inserting the following records
I feel that select statement on tab1 would return me the last 2 records, (11 Ravi and 12 Ram) as per the informational constraint. But I'm getting all the inserted records in the output.
Can any one help me on this?
Informational constraints are strictly to help the optimizer to understand the type of contents and values of the column and get better optimized queries
Otherwise, for your application/SQL resultset, informational constrains do not mean anything serious ..
Visit the new-look IDUG Website
, register to gain access to the excellent content.
You can implement what you want through a view:
create view myview as select * from tab1 where num > 10
Then when you run you query, do it against the view:
select * from myview
should get you the results you want.