Skip to Content
0
Former Member
May 24, 2005 at 02:33 AM

Performance Tuning

12 Views

1)While making a select if one of the key fields has always the value as blank, does it help to specify the fields as part of select OR it won't contribute anything to improved performance.

2) Does performance becomes better if the select avoids non key fields while making select with a partial primary key i.e. make select based on only available key fields ,populate the data in an internal table and then filter out.

Thanks,

Vikas