Physical and Logical Order

DROP TABLE [dbo].[Table_1]
DROP TABLE [dbo].[Table_2]
GO

GO



CREATE TABLE [dbo].[Table_1](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NULL,
 CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

Insert into Table_1 (name) Values
('Switin'),
('Jitesh'),
('Shiv'),
('Ramesh'),
('Apple'),
('Mango')
Go

-- This is Physical order {Clustrued index}
Select * from Table_1

Go


CREATE TABLE [dbo].[Table_2](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NULL,
 CONSTRAINT [PK_Table_2] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

SET ANSI_PADDING ON

GO

/****** Object:  Index [IX_Table_2]    Script Date: 17/06/16 15:44:00 ******/
CREATE NONCLUSTERED INDEX [IX_Table_2] ON [dbo].[Table_2]
(
[Name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO





Go


Insert into Table_2 (name) Values
('Switin'),
('Jitesh'),
('Shiv'),
('Ramesh'),
('Apple'),
('Mango')
Go

Select * from Table_2 -- This is Logical order





/****** Object:  Index [IX_Table_2]    Script Date: 17/06/16 15:44:00 ******/
CREATE NONCLUSTERED INDEX [IX_Table_1] ON [dbo].[Table_1]
(
[Name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO