SQL Query Processing & Optimization || DBMS Session 43

preview_player
Показать описание
Understand how SQL Query gets processed & executed, just like any other high level language program.

Let's learn every bit of it !!
#sql #queryprocessing
Рекомендации по теме
Комментарии
Автор

Very clear and concise. Helped a lot, thank you ma'am!

arnavaggrawal
Автор

Thnqqqq so much mam for hard work it's to much helpful 🔥🔥🔥....🙏🙏🙏🙏🙏🙏🙏🙏

samsharma
Автор

Hi madam thankyou so much for the superb explanation 🙏I have a doubt there are two methods like cost based estimation and heuristic method. You didn't mention about the heuristic way. Actually I was taught to construct a query tree using heuristic rules. I am unable to understand to which part in this process the heuristic query tree should come. I was taught like cost based estimation is difficult and hence heuristic method is used. Could you please clear out my confusion.

ash-xlbb
Автор

is there also different compiler for DQL, DCL and TCL commands.

sanchitsharma
Автор

Maam for placement which topics on dbms should i focus more on ?

BITU