Creating clustered and non-clustered indexes

Question

I was going through the topic of CLUSTERED INDEX & NON-CLUSTERED INDEX, and I gained some pretty good knowledge about how they work and their effect on performance. The very next thought I had was, "HOW TO CREATE THESE INDEXES? and, DO THEY GET CREATED AUTOMATICALLY WHILE CREATING UNIQUE KEY or/and PRIMARY KEY?" WHAT CASES CAN I COME ACROSS IN FUTURE, RELATED TO DEFINING/REDEFINING OF THESE INDEXES?

Please help me with that. Thanks in advance!

Also, these above questions came to my mind after reading these on MSDN pages one & two.

Answer 1

You already found these two pages on Microsoft Docs ("MSDN" or "Microsoft Developer Network" would be the old name):

• Page "one": Clustered and Nonclustered Indexes Described
• Page "two": Create Primary Keys

Some of the answers to your questions are also available on Microsoft Docs:

• SQL Server Index Architecture and Design Guide
  This should provide you with some guidelines towards (future) scenarios where indexes are useful.
• Create Clustered Indexes
  Create Nonclustered Indexes
  Modify an Index
  These pages can get you started on how to create and modify indexes.
• Reorganize and rebuild
  If with "redefine" you meant the maintenance that is required for indexes, then you can start on this documentation page.