You are very welcome. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.
Dear Sir Venkat, u r the best ,urs most honest teaching from basics to high industry level is 0n the TOP among the tutors, mentors eduactors available worldwide & on utubes for c# asp, sql server mvc ..and many more..I wish to see ur face .but cud only hear ur voice...wish u happy healthy long life..u hv done a great work for mankind..in IT ..whether a student is poor or rich ...everyone can get in depth true knowledge from u ..SALUTE u sir
Dear venkat, I went through your all the sql tutorial vedios. you are the best online teacher..I just want to thank you for your time and efforts for these vedios.
Only Thanks is not enough for you. You deserve a lot. I have been watching videos from 1 to 35 for this course. You are just awesome. God bless you man.
Concept explained clearly. When user goes to create index in designer menue are changed from Server versions. I think you may be using 2005 or 2008. I am using SQLEXPRESS2012 and it directly defaults the index to Non-Clustered if there are no indexes'. Also if you could mention what would be default for ASC or DES for a column. Pl note I am suggesting not criticizing. I love your videos. I enjoyed this video. Thanks a bunch
So if you add index, sql performs the same sequential operation, but faster because its easier for sql to work with indexes. Maybe because it has to do with only one column?
I have one question related to index topic. If suppose there are multiple tables in a database and we don't know in which table index is created,now if we want to find all the tables in which index is created,how can we do this?
Give video on below assembly signing dynamic keyword mocking and stuff in Nunit parallal for and foreach synchronization in .net how handle thread safe collection c# idisposable async return type async and await protected internal GACutil strong name gacutil register dll how DLL use in any project closure in JS Grid system in Bootstrap ---_Angular 2--------------- interceptor Event emitter how craete custom directive
Thanks a lot but could you also mention why exactly index is faster, only because it is sorted? If so, whats wrong with using order by instead? If not, then what algo do the index use to speed up the search? In compilers language "7000 will be towards the end" doesn't make any sense to the compiler... You may notice the same question from a couple of people as well in the comments, to answer them... Without indexes it would be a linear search of O (n) to search through every row which is poorest performance, indexes use binery search of O(log n) which is way faster...also making a temp view with order by clause would do the same but more time, size, space , memory and performance are compromised..and Hope that helps.
Don't you have to just go through every cell in the index? Is it just skipping the table sorting step for this one query? If I order by rowid, then will that speed up a query : Select * from table where rowid = 7000 ? Since the row ID is now an index in order?
In SQL Server, when the session that created the global temporary table is closed, the table is also automatically dropped, regardless of whether other active connections are referencing it. Unlike stated that global temporary tables are destroyed when the last connection that is referencing the global temp table is closed.
Venkat, What if we have 2 tables with same structure & 2 million records in each. one have clustered index & other don't have any index. If we write select * query without where clause? what will be the result ? I mean which will give data fast if we are not using where clause in query ?
Great tutorial however i still wanted to understand how sql seeks the index as it doesn't have eyes like we have to see in Book Index :) it still need to go through row by row to fulfill the where clause right? I know not correct but I'm not convinced yet. Also if i want to fetch all records from table then i dont need to have indexes right?
In the Non-Clustered Index table shown at 5:00 what if there are duplicate values in salary, does the database attach multiple addresses to the same salary? (how is that done? like a dictionary with salary as key and list of addresses as value?)
Thank you for the video. I have a question if you can answer please. When we run sp_Helpindex table_name, it would display indexes on that table plus unique/primary keys defined. Am I correct?
Hello Venkat thanks for such a great videos. I have a query.... I am learning Oracle database... can I follow the same videos what you have uploaded on Indexes, stored procedures?? are they same for both Oracle and PL SQL ?
Respect to this guy. I'm employable because of his tutorials
Same xd
🙋🏽♂️ same
same,,,,
Me too
Hii
Can we send Venkat a recognition award or something? I have never fallen in love with SQL, this guy makes it so simple to understand.
why not
"We will talk about it in the next session". I go fast to the next session! Thanx Venkat!
You are very welcome. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.
Dear Sir Venkat, u r the best ,urs most honest teaching from basics to high industry level is 0n the TOP among the tutors, mentors eduactors available worldwide & on utubes for c# asp, sql server mvc ..and many more..I wish to see ur face .but cud only hear ur voice...wish u happy healthy long life..u hv done a great work for mankind..in IT ..whether a student is poor or rich ...everyone can get in depth true knowledge from u ..SALUTE u sir
Thank you so much for helping out the people for free.
#RespectYouSir
Thank you for create every student to Understand practical with example so a effect for all tutorial. Thank you brother.
Thank you Venkat for the wonderful gift of Knowledge. Good bless you
Dear venkat, I went through your all the sql tutorial vedios. you are the best online teacher..I just want to thank you for your time and efforts for these vedios.
i like ur teaching style (great teacher ),love from pakistan.
Only Thanks is not enough for you. You deserve a lot. I have been watching videos from 1 to 35 for this course. You are just awesome. God bless you man.
Why are you watching just 1 to 35?
@@amruthavarshinichaganti5667 he commented at the video he has reached for now ( this video -> Part 35
Revisited to refresh my memory.
Thanks a bunch
You are the best man. Keep your education mission ;-) Best Regards ;-)
This is old, but this is the best course you can find online!
Venkat your communication us wonderfull..nice explanation
Concept explained clearly. When user goes to create index in designer menue are changed from Server versions. I think you may be using 2005 or 2008. I am using SQLEXPRESS2012 and it directly defaults the index to Non-Clustered if there are no indexes'. Also if you could mention what would be default for ASC or DES for a column. Pl note I am suggesting not criticizing. I love your videos. I enjoyed this video. Thanks a bunch
Very clear and sumple explanation, thanks.
Excellent explanation, easy to understand. Thank you!
you are amazing thank you for all the videos
Thanks it helped!
Very nice learning experience
Perfect explanation. Many thanks.
My very first source of learning sql was this channel, learner a lot
You should have mentioned about the binary search that takes place on the separate table that is created with
sorted key values
Its a B-TREE not a BST
Thankyou very much sir.it's really understandable
what is index fragmentation and defragmentation? How it affects DB performance?
The best explanation of indexes till now! Thank you so much for this.
nice explanation ....thank you
Really sweat teaching !!!!
very good tutorial. thanx
you are amazing!!
thankyou so much sir..
great explanation....:)
Rewatched.
Thanks a lot for educating community
So if you add index, sql performs the same sequential operation, but faster because its easier for sql to work with indexes. Maybe because it has to do with only one column?
Excellent work sir .I am able to work as DBA just bcoz of you . hat's off to you..
Thanks for the Video ...
thank you very much sir☺
video was very helpful
Kudvenkat you are awesome. Thank for all your uploads!!!
Please watch videos in speed 1.5 or 2, it will more effective.
hi dude, i've learnt a lot from u
Greetings from mexico
Thanks for all your help! Best SQL Tutor... Was wondering if you have classes on BIG DATA or JAVA
why can't we simply use "ORDER BY" ?
i read tens of documents but still couldn't grasp the topic,, watched your video, and boom!!
I have one question related to index topic.
If suppose there are multiple tables in a database and we don't know in which table index is created,now if we want to find all the tables in which index is created,how can we do this?
watching in 2023 ...
wondering how you created such awesome content 11 years ago !!👏
Hi venkat
I want to learn sql development. Do you have sessions or coaching. Let me know is there any.
Give video on below
assembly signing
dynamic keyword
mocking and stuff in Nunit
parallal for and foreach
synchronization in .net how handle
thread safe collection c#
idisposable
async return type
async and await
protected internal
GACutil
strong name
gacutil register dll
how DLL use in any project
closure in JS
Grid system in Bootstrap
---_Angular 2---------------
interceptor
Event emitter
how craete custom directive
Can anyone tell me what would possibly happen if we apply indexing on a string column.
You are my hero! Each time I need to check up on some relevant topics, I can find them on your channel.
Thank You for video. Is there any video where one can see how indexes are used ? I mean to see how fast became the query
perfect Videos for beginners. Thanks Venkat..
what if we have multiple indexes on same table and what to remove particular index
Thanks a lot but could you also mention why exactly index is faster, only because it is sorted? If so, whats wrong with using order by instead? If not, then what algo do the index use to speed up the search? In compilers language "7000 will be towards the end" doesn't make any sense to the compiler... You may notice the same question from a couple of people as well in the comments, to answer them... Without indexes it would be a linear search of O (n) to search through every row which is poorest performance, indexes use binery search of O(log n) which is way faster...also making a temp view with order by clause would do the same but more time, size, space , memory and performance are compromised..and Hope that helps.
Don't you have to just go through every cell in the index? Is it just skipping the table sorting step for this one query?
If I order by rowid, then will that speed up a query : Select * from table where rowid = 7000 ? Since the row ID is now an index in order?
Nobody can teach better than you..
sir.. u miss one point that indexer are internally works on B-TREE .. that it provides good performance :) and efficient searching
In SQL Server, when the session that created the global temporary table is closed, the table is also automatically dropped, regardless of whether other active connections are referencing it. Unlike stated that global temporary tables are destroyed when the last connection that is referencing the global temp table is closed.
Very good video for a beginner. Thank you
Venkat,
What if we have 2 tables with same structure & 2 million records in each.
one have clustered index & other don't have any index.
If we write select * query without where clause? what will be the result ?
I mean which will give data fast if we are not using where clause in query ?
Great tutorial however i still wanted to understand how sql seeks the index as it doesn't have eyes like we have to see in Book Index :) it still need to go through row by row to fulfill the where clause right? I know not correct but I'm not convinced yet. Also if i want to fetch all records from table then i dont need to have indexes right?
In the Non-Clustered Index table shown at 5:00 what if there are duplicate values in salary, does the database attach multiple addresses to the same salary? (how is that done? like a dictionary with salary as key and list of addresses as value?)
very nice sir , thankyou for this
Really appreciate your contributions :D
Kudvenkat, you are the best!!!!!!!!! RUclips needs to seriously pay you for such a talent!
please sir upload a detail lecture about the differences b/w sql server 2000 to 2019.
very clear video. thanks very much.
I am brazilian and not advanced in English, but I like your videos and the subtitles helps a lot. Thank you.
This is one of the few times I pause the adblock. Keep up the good work. If we can support you and your work in some way, let us know
very very nice.
Kudvenkat, you did a great job on this video. Your English is also very good.
This was the best explanation I have heard, thanks Kudvenkat....you are the best.
Bro explain about HEAP table and difference between varchar and nvarchar and char
Nice explanation and very impressed
this is great, but I have a question, what differ the index from the table of content in a book?
I just gone through bcos i was asked about the indexes in interview today.... and found this very useful... thanks for sharing
Thank you for the video. I have a question if you can answer please. When we run sp_Helpindex table_name, it would display indexes on that table plus unique/primary keys defined. Am I correct?
Thanks for your information. solve lot of loading problem
Sir .. Thank you very much.........
For your valuable videos
hi , i really like your all tutorials ,thank you so much to be teach me ,you r the best teacher
Very useful video thank you
Hello Venkat
thanks for such a great videos.
I have a query.... I am learning Oracle database... can I follow the same videos what you have uploaded on Indexes, stored procedures??
are they same for both Oracle and PL SQL ?
thank you for these videos.
i have a general knowledge in computing. do you provide tutorials lessons for those who want to be SQL certified?
Awesome explanation .Clearly understood
Thanks for the video, great explanation!
Kiril Anastasov 5 6o6
Hi Sir kudvenkat ,
Have you written any book?
the best explanation and videos i have never watched before. thanks a lot sir!
You're a brilliant teacher. I greatly appreciate your tutorials🙌
Best tutorial ever
Thanks for sharing. These videos are very helpful
Who dislike Venkat Sir video , there are aliens.
You are the best man. Keep your education mission
Why does it give you options to add more than one column as key to the index (window displayed at 10:44)?
ah, would it be for composite indices?
Thank you for doing this extremely helpful
thank you for these tutorials
Man I LOVE YOU.. NO homo..you are a great tutor.
super
Wowwwwwwwwww, thats it, my select query run 50x faster. Sir well done and I appreciate it.
Hi Kerem - Thank you for letting us know. Great news. Indexes are great from a performance standpoint when reading data.
thank you so much you have made the description so much easier to understand
indexes are like bookmarks
Thank you
A good start towards working with Indexes. Eager to learn more on Index, so starting with the next video of the series.
Thank you!