How does query parameters work under the hood?

Asked 9 months ago

Viewed 21 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,3028 silver badges17 bronze badges

asked Feb 13 at 11:10

Joelty

1212 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 at 11:20
Pro SQL Server Internals, Microsoft SQL Server 2012 Internals – McNets Feb 13 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