??????? ????????? -???

????????? ???

????????? ??? ???? ????? ?????? , ?? ???????? ???? ?????? ????? ????? ??? ???? ??????? ???? ??? ???? ???? ????? sorted list ???? ???, ?????? ???????? ?????? ?????? ??????? ???? ? ??? ???? query ????? ??? ???? ????? ?????? ????? ??? ?? ??????? ?? ??????? ???? ????????? ???? ???? ????? ??? ??? ?

????????? ?? ?????????

???????? ?????????-?? ??? ??????? ??? ??????, ??? ?????? ??????? ???:

????????? ??????? (Primary Index): ??? ??????? primary key ?? ??? ?????? ??? ???? ??? ??? ??????? ??????? row ?? ????? ???? Identify ????

?????????? ??????? (Secondary Index): ????????? ?? ????? ???????? ?????? ??? ??????? ???? ??? ????

?????????? ??????? (Clustered Index): ??? ??????? ?????? physically sorted ??? ?????

??-?????????? ??????? (Non-clustered Index): ???? ???? ?????????? physically sorted ??? ???? ??? ??? ????? ???????? ???? ????? ??? ????

????? Non-clustered ??????? ?? ??????? ???? ?????? ??? ????? ??????? ??? ??????? ??? ?

???? ?????? ???? Employee ????? ???,

EmployeeID Name Department DateOfJoining

1 Rakib IT 2021-05-10

2 Siam HR 2020-03-15

3 Anik Finance 2022-07-18

4 Rakib Marketing 2019-08-20

5 Arif Marketing 2023-01-10

??? ?? ????? ???? Rakib ???? ??? employee ??? ???? ?????? ?????? ? ???? ???? ???? ????????? ???? ??? ????????? ???? ???? ?????? ?????? ??? ???? ???? ??? ???? ??? ?

????????? ????? ?? ???

??? ????????? ?? ????, ????? ????????? ??????? row ??? ???? ????? ?? Rakib ???? ??? ??? ????? ?? ????, ??????? ????? row ???? ???? ??? ??????? row sequentially ??? ????, ??? ?????? Rakib????, ???? ???????

Query:

SELECT * FROM Employee WHERE Name = 'Rakib';        

????? ????????? ??????? row ??? ??? ????? ??? ??? ??? ???? ?????? ???? ???? ??? ????? ?

????????? ?? ?????? ??? ????

??? ??? ???? Name ?????? ??? ???? ??????? ???? ???, ??????? ???? ????? sorted ????? ???? ???? ??? ?? ?????? ???? ????? ????? ?????

??????? ????? (sorted):

Name ????????? (EmployeeID)

Anik 3

Arif 5

Rakib 1, 4

Siam 2

??? ??? ???? Rakib ?? ?????? ??? , ??????? ?????? ??????? ??????? sorted ????? ???? Rakib ?? ??? ????? ???? ??? ??? ???? ???? ????????? (EmployeeID) ???? ????? ?? Rakib ?? ???????? 1 ??? 4 ????? row ?? ??????? ???? ??????? ?? row ???? ???? ??? ???? ????? ?????

Query:

SELECT * FROM Employee WHERE Name = 'Rakib';        

??????? ??????? ?????? ????? Rakib ????? ?????

Rakib ?? ???? 1 ??? 4 ????? row ?? ????????? ?????? ?????

??????? ?????? 1 ??? 4 ????? row ???? ???? ????? ?????

????? ??????? row sequentially ??? ???? ????? ?????, ??????? ???? ?????? ????????? ??? ???? ????? ??? ??????? ??? search speed ???? ????? ?????

????????? ?? ??????

????????? ?? ??????? ????????? ??????? row ??? ??? ????? ??? ??, ??? sorted ??????? ???? ?????? ????? ????????? ????? ??? ???, ??? ???? ????? ????? ??? ??? ??? ?

??? ??? ?????? ????????? ?? ??????? query execution ???? ????? ???, ?? ??????? ?????????????? ???????? ?????

?????? ????????? ???? ????????? ?????? , ?? ????????? ?????????????? ???? ?????? ??? ? ???????? ????????? ???? ??? ??????? ????? ????? ???? ????? ??? ??? ?????? ???, ???? ??? ????????? ???? ??? ??? ???, ??? ????????? ??????? ??? ???????????

???? ????????????? ????????? ??? ?? ????? ????? ???, ?? ????????? ?????????????? ?????? ??? ?

???? ?? ???????? ??? ???? ???? ???? ??? ????????? ?????