How does query parameters work under the hood?

Asked 1 year ago

Viewed 34 times

I thought about how can it work under the hood and I came with an idea

Db engine receives query with parameters and also defined values of those parameters
SQL is being parsed into syntax tree like that

After parsing values of parameters are inserted into tree to places where associated with them parameters are
Query is being executed without another parsing

Is it at least conceptually true?

eckes

1,3288 silver badges18 bronze badges

asked Feb 13 '19 at 11:10

Joelty

1013 bronze badges

That depends on the actual database engine beeing used, however I would agree that an efficient engine would not do string replacement and parse the query again (but I am also sure there are engines which are not so sophisticated). For Oracle there is a soft/hard parse destination and parameter binding is one of the phases after that. – eckes Feb 13 '19 at 11:20
Pro SQL Server Internals, Microsoft SQL Server 2012 Internals – McNets Feb 13 '19 at 11:35

add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy