What is the mean of Try to have the constraints in the 'Selection' criteria of the jobs itself. This will eliminate the unnecessary records even getting in before joins are made?

  • Interview Candidate
  • 3
  • 1937

Showing Answers 1 - 3 of 3 Answers

dimple

  • Nov 21st, 2005
 

It probably means that u can put the selection criterai in the where clause,i.e whatever data u need to filter ,filter it out inthe SQL ,rather than carrying it forward and then filtering it out.

  Was this answer useful?  Yes

Sharanu Patil

  • Feb 28th, 2006
 

Constraints is nothing but restrictions to data.here it is restriction to data at entry itself , as he told it will avoid unnecessary data entry .

  Was this answer useful?  Yes

Venkat

  • May 22nd, 2006
 

This means try to improve the performance by avoiding use of constraints wherever possible and instead using them while selecting the data itself using a where clause. This improves performace.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.