covering Index | covering index in sql | covering Index in SQL Server
In This Video we are going to learn,
Covering Index in SQL Server
Your Queries,
Unique nonclustered Index
Unique Index
clustered index
cluster and non cluster index
cluster and non clustered index
clustered non clustered index
difference between clustered and non clustered index
non clustered index
filtered index
filtered index in sql server
Index seek
Index scan
Table Scan
Notes / SQL Query link:
https://learnsqlwithsagar.blogspot.com
Query
CREATE NONCLUSTERED INDEX [IX_Patient_CityID_Name]
ON [dbo].[Patient] ([CityID])
INCLUDE ([FirstName],[MiddleName],[LastName])
GO
Select FirstName,MiddleName,LastName from Patient where CityID=1
Select FirstName,MiddleName,LastName from Patient where PatientID=4
My key Links-
🚀 YouTube Videos- / @mssqlexpert
🌍 My website / blog - https://learnsqlwithsagar.blogspot.com/
📸 Instagram - / learnsqlwithsagar
🚀 YouTube Shorts - / @mssqlexpertshorts
Who am I :
Hey guys, I am Sagar, welcome to this channel - #mssqlexpert. this channel is all about learning SQL Server. my goal is to help you in SQL server learning.
and Learn complete SQL from basics to Expert Level with an Industrial Knowledge.
This SQL course is for beginners who having zero knowledge in SQL. Even those having SQL knowledge they will also get deep information about SQL Language & Microsoft SQL Server (RDBMS). This course will cover how to write SQL Query in MS SQL Server. We will go through a Database, Database Objects (Table, View, Stored Procedure, Function, Trigger, Cursor), Different SQL Queries, Joining, Temp Table, Table Variable, CTE, Indexing, Stats, Query Execution plan, Query Optimization and much more.
Please Like, Share, Subscribe, & Comment.
Featured playlist
• SQL Course | SQL Full Course 2024 | sql fu...
• Database Knowledge
• SQL project
• MySQL
#mssqlexpert #sql #sql course #data #database #sql server #sqlserver #mssqlserver #RDBMS #sql tutorial #sql full course #sql tutorial for beginners
#sql for data analysis #sql for beginners