Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dyn SQL performance.

Status
Not open for further replies.
CapsuleCorpJX

CapsuleCorpJX

IS-IT--Management
Jun 23, 2004
70
US
Hey I use dynamic SQL in my stored procedures so I can pass the database name as a parameter.

Does anyone know if a regular stored procedure runs faster than a stored procedure that uses dynamic sql?
 
Sort by date Sort by votes
Probably not, because the SQL must be parsed and optimized by the PE regardless if it's dynamic or not.

Dieter
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tmcrouse
  • Locked
  • Question
Tera SQL Update help
Replies
2
Views
129
tmcrouse
tmcrouse
btrini
  • Locked
  • Question
Fastload logon shows as invalid but I can log on to Teradata SQL Assistant with the same credentials
Replies
1
Views
123
SamBones
SamBones
dprayner
  • Locked
  • Question
Teradata SQL Assistant query - Condition in WHERE statement
Replies
1
Views
96
glenntb
glenntb
peac3
  • Locked
  • Question
Dynamic Join help please... tough query
Replies
0
Views
105
peac3
peac3
abhijeetgupta29nov
  • Locked
  • Question
Help Sql: Please verify solution and let me know if any better to achieve this ....
Replies
0
Views
61
abhijeetgupta29nov
abhijeetgupta29nov

Part and Inventory Search

Sponsor

Back
Top