Some simple points might cause Performance Issue.

来源:互联网 发布:autodesk软件介绍 编辑:程序博客网 时间:2024/06/16 08:15

 

1. using calculate fields in the Search Expression. .

 

 

It will cause Siebel to open up the cursor and process the records one by one.

like Len/Right/Instr

 

 

2. Order by on a column without index.