Hi All,

We had a applications built on oracle forms9i/Oracle 9i , after
OLS(Oracle Label Security) was implemented the performance went down
drastically.

I was trying to analyze the situation ,I am new to OLS and i believe
OLS engine just appends the extra condition in the where clause of the
original query

Ex: if the original query was
select emo_no,name from employee;

OLS will append the extra condition as

select emo_no,name from employee where <<label_column>> = <<label>>;


Since there is performance degradation after implementing OLS , can
you guys please let me know what are all the possibilities which can
lead to this

Is the original queries not using indexes or there can be something
else also

Please reply

Thanks in Advance

SK