----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: VinodK [TLabs, SCT] Message 5 in Discussion Hi Senthil, >> will there be any performance issue, if we form huge and/or logical combinations dynamically? Well the answer to this is going to be on what performance is to you ... Well if I were to compare a static query that uses this construct then as Raj has said there would be hardly any performance overhead that you have to think of ... This is because the DB identifies the index and optimizes the whole operation ... Now on the other side ... If I were to compare a static query to a D-SQL ie Dynamic statement using a Exec/sp_executesql would always have some performance hit because the whole query have to get parsed, compiled and exection tree has to be formed before actually fetching the query ... Moreover D-SQL always has a overhead as it is considered as adhoc queries ... Hope I've made you clear here ... HTH, Vinod Kumar SCT Software Solutions ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
