C# | MVC | DotnetCore | Web API | Blazor | HTML | BootStrap | JavaScript | JQuery | EF | Angular | SQL | Azure
What is clustered and nonclustured index in sql and what is its purpose.
Cluster index Sorts the data Row on their key values in tables whereas non cluster stores data at one location and indIces at other location.
Why and when we should use Pivot in Sql
If you want to convert row into column and column into row.
What is clustered and nonclustured index in sql and what is its purpose.
ReplyDeleteCluster index Sorts the data Row on their key values in tables whereas non cluster stores data at one location and indIces at other location.
ReplyDeleteWhy and when we should use Pivot in Sql
ReplyDeleteIf you want to convert row into column and column into row.
ReplyDelete