SQL : SP taking 15 minutes, but the same query when executed returns results in 1-2 minutes

Channel:
India Hey Delphi
Subscribers:
76,400
Published on ● Video Link: https://www.youtube.com/watch?v=hhkdbHq4uuk


Duration: 1:51
0 views
0

SQL : SP taking 15 minutes, but the same query when executed returns results in 1-2 minutes
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

As promised, I have a secret feature that I want to reveal to you.
This is a YouTube's feature which works on Desktop.
First, Make sure the video is currently in playing mode.
Then, type the letters 'awesome' on the keyboard.
It will change your youtube progress bar into a flashing rainbow.

Let me give you a brief introduction of who I am,
Hello everyone, I'm Delphi.
I can assist you in answering your queries.
SQL : SP taking 15 minutes, but the same query when executed returns results in 1-2 minutes
I welcome your comments and chats if you have more detailed queries.
Your input is appreciated, so please leave a comment below with your answer or insights to the answer.
A 'heart' from me will indicate my appreciation for your answer.
when executed : in query but 1-2 SQL the same SP returns taking minutes minutes, 15 results



Other Videos By Hey Delphi


2023-05-16jQuery : Jquery Mobile pageshow function
2023-05-16C++ : Ambiguity between default-initialization and value-initialization
2023-05-16R : list of character vectors of unequal length to data.frame
2023-05-16Array : Dynamically changing array of structures in C
2023-05-16Array : Android: Can I pass an array of Parcelable objects? Do I need to create a wrapper object?
2023-05-16NodeJS : Found extra flags error in new version of protractor
2023-05-16SQL : Performing binary comparison of MySQL field values with SQL
2023-05-16Array : Split a numpy column into two columns and keep them in the original array
2023-05-16HTML : Bootstrap 3: Push/pull columns over rows
2023-05-16Android : Exception 'open failed: EACCES (Permission denied)' on Android
2023-05-16SQL : SP taking 15 minutes, but the same query when executed returns results in 1-2 minutes
2023-05-16C++ : One makefile for two compilers
2023-05-16R : Correlation between numeric and logical variable gives (intended) error?
2023-05-16C++ : Lambda function with different signatures from std::function
2023-05-16jQuery : Bootstrap 4 .modal('hide') not working
2023-05-16jQuery : Cursor-following div - Disappears when mouse moves down or right
2023-05-16Django : Pyapns Fault 500: 'Connection to the APNS server could not be made
2023-05-16HTML : Bootstrap 3 div over jumbotron
2023-05-16R : Protect/encrypt R package code for distribution
2023-05-16C++ : Non-recursive make: include makefile segment in a loop
2023-05-16C# : Dependency Injection circular dependency .NET Core 2.0