{"id":9367,"date":"2025-04-15T09:53:47","date_gmt":"2025-04-15T02:53:47","guid":{"rendered":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/?p=9367"},"modified":"2025-04-15T09:57:10","modified_gmt":"2025-04-15T02:57:10","slug":"index-trong-database-la-gi","status":"publish","type":"post","link":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/tu-van-nghe-nghiep\/index-trong-database-la-gi","title":{"rendered":"Index trong database l\u00e0 g\u00ec? To\u00e0n t\u1eadp ki\u1ebfn th\u1ee9c t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao"},"content":{"rendered":"\n

C\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng trong vi\u1ec7c l\u01b0u tr\u1eef v\u00e0 qu\u1ea3n l\u00fd th\u00f4ng tin cho h\u1ea7u h\u1ebft c\u00e1c \u1ee9ng d\u1ee5ng c\u00f4ng ngh\u1ec7 ng\u00e0y nay. Khi kh\u1ed1i l\u01b0\u1ee3ng d\u1eef li\u1ec7u ng\u00e0y c\u00e0ng l\u1edbn, nhu c\u1ea7u t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t truy v\u1ea5n tr\u1edf th\u00e0nh m\u1ed9t y\u1ebfu t\u1ed1 b\u1eaft bu\u1ed9c \u0111\u1ed1i v\u1edbi c\u1ea3 l\u1eadp tr\u00ecnh vi\u00ean l\u1eabn qu\u1ea3n tr\u1ecb vi\u00ean h\u1ec7 th\u1ed1ng. Vi\u1ec7c \u0111\u1eb7t c\u00e2u h\u1ecfi index trong database l\u00e0 g\u00ec<\/strong> th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi hi\u1ec7u n\u0103ng truy xu\u1ea5t d\u1eef li\u1ec7u kh\u00f4ng \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c k\u1ef3 v\u1ecdng v\u00e0 c\u1ea7n gi\u1ea3i ph\u00e1p chuy\u00ean s\u00e2u h\u01a1n \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c truy v\u1ea5n nhanh ch\u00f3ng, ch\u00ednh x\u00e1c m\u00e0 v\u1eabn ti\u1ebft ki\u1ec7m t\u00e0i nguy\u00ean.<\/p>\n\n\n\n

\"Index<\/figure>\n\n\n\n

Index trong Database l\u00e0 g\u00ec?<\/h2>\n\n\n\n
\n

Index trong Database (ch\u1ec9 m\u1ee5c trong c\u01a1 s\u1edf d\u1eef li\u1ec7u) l\u00e0 m\u1ed9t c\u1ea5u tr\u00fac d\u1eef li\u1ec7u \u0111\u1eb7c bi\u1ec7t \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u0103ng t\u1ed1c \u0111\u1ed9 truy v\u1ea5n v\u00e0 truy xu\u1ea5t th\u00f4ng tin trong c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u.<\/strong><\/p>\n<\/blockquote>\n\n\n\n

Index ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 m\u1ee5c l\u1ee5c trong m\u1ed9t cu\u1ed1n s\u00e1ch, gi\u00fap h\u1ec7 th\u1ed1ng x\u00e1c \u0111\u1ecbnh nhanh v\u1ecb tr\u00ed b\u1ea3n ghi c\u1ea7n t\u00ecm m\u00e0 kh\u00f4ng ph\u1ea3i duy\u1ec7t qua to\u00e0n b\u1ed9 b\u1ea3ng. Index kh\u00f4ng l\u00e0m thay \u0111\u1ed5i n\u1ed9i dung d\u1eef li\u1ec7u g\u1ed1c, nh\u01b0ng \u0111\u00f3ng vai tr\u00f2 then ch\u1ed1t trong vi\u1ec7c n\u00e2ng cao hi\u1ec7u su\u1ea5t v\u00e0 t\u1ed1i \u01b0u h\u00f3a ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n\n\n\n

Vai tr\u00f2 v\u00e0 c\u01a1 ch\u1ebf ho\u1ea1t \u0111\u1ed9ng c\u1ee7a Index trong Database<\/h2>\n\n\n\n

Index trong Database kh\u00f4ng ch\u1ec9 \u0111\u01a1n thu\u1ea7n l\u00e0 c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 m\u00e0 c\u00f2n \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng trong vi\u1ec7c t\u1ed1i \u01b0u h\u00f3a hi\u1ec7u su\u1ea5t truy v\u1ea5n, nh\u1ea5t l\u00e0 v\u1edbi c\u00e1c h\u1ec7 th\u1ed1ng d\u1eef li\u1ec7u l\u1edbn v\u00e0 ph\u1ee9c t\u1ea1p. Hi\u1ec3u r\u00f5 ch\u1ee9c n\u0103ng v\u00e0 c\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng c\u1ee7a Index gi\u00fap l\u1eadp tr\u00ecnh vi\u00ean, qu\u1ea3n tr\u1ecb vi\u00ean Database thi\u1ebft k\u1ebf h\u1ec7 th\u1ed1ng hi\u1ec7u qu\u1ea3 v\u00e0 tr\u00e1nh \u0111\u01b0\u1ee3c nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn khi thao t\u00e1c v\u1edbi d\u1eef li\u1ec7u.<\/strong><\/p>\n\n\n\n

T\u1ea7m quan tr\u1ecdng c\u1ee7a Index trong truy v\u1ea5n Database<\/h3>\n\n\n\n

Trong m\u00f4i tr\u01b0\u1eddng c\u01a1 s\u1edf d\u1eef li\u1ec7u, t\u1ed1c \u0111\u1ed9 truy v\u1ea5n \u0111\u00f3ng vai tr\u00f2 then ch\u1ed1t trong vi\u1ec7c \u0111\u1ea3m b\u1ea3o hi\u1ec7u su\u1ea5t h\u1ec7 th\u1ed1ng. Khi d\u1eef li\u1ec7u ng\u00e0y c\u00e0ng t\u0103ng l\u00ean v\u1ec1 quy m\u00f4 v\u00e0 \u0111\u1ed9 ph\u1ee9c t\u1ea1p, c\u00e1c truy v\u1ea5n kh\u00f4ng c\u00f3 s\u1ef1 h\u1ed7 tr\u1ee3 c\u1ee7a Index s\u1ebd ph\u1ea3i qu\u00e9t to\u00e0n b\u1ed9 b\u1ea3ng (full table scan), d\u1eabn \u0111\u1ebfn th\u1eddi gian x\u1eed l\u00fd l\u00e2u v\u00e0 ti\u00eau t\u1ed1n t\u00e0i nguy\u00ean. Index gi\u00fap c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t truy v\u1ea5n b\u1eb1ng c\u00e1ch r\u00fat ng\u1eafn th\u1eddi gian t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u, gi\u1ea3m \u00e1p l\u1ef1c l\u00ean b\u1ed9 nh\u1edb v\u00e0 CPU, \u0111\u1eb7c bi\u1ec7t trong c\u00e1c h\u1ec7 th\u1ed1ng c\u00f3 h\u00e0ng tri\u1ec7u b\u1ea3n ghi. Ch\u00ednh v\u00ec v\u1eady, vi\u1ec7c s\u1eed d\u1ee5ng Index m\u1ed9t c\u00e1ch h\u1ee3p l\u00fd l\u00e0 y\u1ebfu t\u1ed1 quy\u1ebft \u0111\u1ecbnh trong vi\u1ec7c t\u1ed1i \u01b0u h\u00f3a ho\u1ea1t \u0111\u1ed9ng c\u1ee7a Database.<\/p>\n\n\n\n

C\u01a1 ch\u1ebf ho\u1ea1t \u0111\u1ed9ng c\u1ee7a Index trong vi\u1ec7c truy xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb Database<\/h3>\n\n\n\n

Index ho\u1ea1t \u0111\u1ed9ng b\u1eb1ng c\u00e1ch t\u1ea1o ra m\u1ed9t c\u1ea5u tr\u00fac ri\u00eang bi\u1ec7t \u2014 th\u01b0\u1eddng l\u00e0 c\u00e2y B-Tree ho\u1eb7c Hash Table<\/strong> \u2014 \u0111\u1ec3 \u00e1nh x\u1ea1 gi\u1eefa gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t v\u1edbi v\u1ecb tr\u00ed l\u01b0u tr\u1eef c\u1ee7a b\u1ea3n ghi t\u01b0\u01a1ng \u1ee9ng trong b\u1ea3ng. Khi th\u1ef1c hi\u1ec7n truy v\u1ea5n, thay v\u00ec t\u00ecm ki\u1ebfm t\u1eebng d\u00f2ng d\u1eef li\u1ec7u trong b\u1ea3ng, h\u1ec7 th\u1ed1ng s\u1ebd t\u00ecm trong Index \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c v\u1ecb tr\u00ed d\u1eef li\u1ec7u c\u1ea7n truy xu\u1ea5t. V\u00ed d\u1ee5, khi c\u00f3 Index tr\u00ean c\u1ed9t \u201cemail\u201d, truy v\u1ea5n l\u1ecdc theo \u0111\u1ecba ch\u1ec9 email s\u1ebd ch\u1ec9 c\u1ea7n tra c\u1ee9u trong Index, gi\u00fap r\u00fat ng\u1eafn \u0111\u00e1ng k\u1ec3 th\u1eddi gian t\u00ecm ki\u1ebfm. C\u01a1 ch\u1ebf n\u00e0y gi\u1ed1ng nh\u01b0 vi\u1ec7c s\u1eed d\u1ee5ng m\u1ee5c l\u1ee5c \u0111\u1ec3 t\u00ecm nhanh n\u1ed9i dung trong s\u00e1ch thay v\u00ec \u0111\u1ecdc to\u00e0n b\u1ed9.<\/p>\n\n\n\n

So s\u00e1nh vi\u1ec7c truy v\u1ea5n d\u1eef li\u1ec7u trong Database c\u00f3 v\u00e0 kh\u00f4ng c\u00f3 Index<\/h3>\n\n\n\n

Khi kh\u00f4ng c\u00f3 Index, h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u bu\u1ed9c ph\u1ea3i th\u1ef1c hi\u1ec7n full table scan<\/strong>, t\u1ee9c l\u00e0 ki\u1ec3m tra t\u1eebng d\u00f2ng m\u1ed9t \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p v\u1edbi \u0111i\u1ec1u ki\u1ec7n truy v\u1ea5n. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t t\u1ed1n th\u1eddi gian n\u1ebfu b\u1ea3ng c\u00f3 h\u00e0ng ngh\u00ecn ho\u1eb7c h\u00e0ng tri\u1ec7u d\u00f2ng. Ng\u01b0\u1ee3c l\u1ea1i, khi c\u00f3 Index, truy v\u1ea5n s\u1ebd chuy\u1ec3n sang index seek<\/strong>, ch\u1ec9 \u0111\u1ecbnh v\u1ecb \u0111\u1ebfn d\u00f2ng d\u1eef li\u1ec7u c\u1ea7n t\u00ecm m\u00e0 kh\u00f4ng ph\u1ea3i qu\u00e9t to\u00e0n b\u1ed9. K\u1ebft qu\u1ea3 l\u00e0 t\u1ed1c \u0111\u1ed9 ph\u1ea3n h\u1ed3i nhanh h\u01a1n, gi\u1ea3m t\u1ea3i cho h\u1ec7 th\u1ed1ng, v\u00e0 n\u00e2ng cao tr\u1ea3i nghi\u1ec7m ng\u01b0\u1eddi d\u00f9ng ho\u1eb7c hi\u1ec7u qu\u1ea3 x\u1eed l\u00fd backend trong c\u00e1c \u1ee9ng d\u1ee5ng l\u1edbn.<\/p>\n\n\n\n

V\u00ed d\u1ee5 minh h\u1ecda Index trong th\u1ef1c t\u1ebf s\u1eed d\u1ee5ng Database<\/h3>\n\n\n\n

Gi\u1ea3 s\u1eed c\u00f3 m\u1ed9t b\u1ea3ng KhachHang ch\u1ee9a h\u00e0ng tr\u0103m ngh\u00ecn d\u00f2ng d\u1eef li\u1ec7u, trong \u0111\u00f3 c\u00f3 c\u1ed9t SoDienThoai. Khi ng\u01b0\u1eddi d\u00f9ng nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u0111\u1ec3 t\u00ecm kh\u00e1ch h\u00e0ng, n\u1ebfu kh\u00f4ng c\u00f3 Index, h\u1ec7 th\u1ed1ng s\u1ebd ph\u1ea3i duy\u1ec7t to\u00e0n b\u1ed9 b\u1ea3ng \u0111\u1ec3 t\u00ecm s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ph\u00f9 h\u1ee3p. Tuy nhi\u00ean, n\u1ebfu c\u1ed9t SoDienThoai \u0111\u01b0\u1ee3c \u0111\u00e1nh Index, h\u1ec7 th\u1ed1ng s\u1ebd tra c\u1ee9u nhanh trong Index \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c d\u00f2ng d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng, ch\u1ec9 m\u1ea5t m\u1ed9t v\u00e0i mili-gi\u00e2y. Trong c\u00e1c h\u1ec7 th\u1ed1ng th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed, ng\u00e2n h\u00e0ng, ho\u1eb7c \u1ee9ng d\u1ee5ng th\u1eddi gian th\u1ef1c, vi\u1ec7c \u00e1p d\u1ee5ng Index l\u00e0 b\u1eaft bu\u1ed9c \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o truy v\u1ea5n d\u1eef li\u1ec7u di\u1ec5n ra m\u01b0\u1ee3t m\u00e0 v\u00e0 hi\u1ec7u qu\u1ea3.<\/p>\n\n\n\n

\n

Xem th\u00eam: Tuy\u1ec3n Nh\u00e2n Vi\u00ean IT<\/a> ta\u0323i Careerlink.vn<\/p>\n<\/blockquote>\n\n\n\n

C\u00e1c lo\u1ea1i Index ph\u1ed5 bi\u1ebfn trong Database<\/h2>\n\n\n\n

Trong h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u, Index \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf d\u01b0\u1edbi nhi\u1ec1u h\u00ecnh th\u1ee9c kh\u00e1c nhau nh\u1eb1m ph\u1ee5c v\u1ee5 nh\u1eefng m\u1ee5c \u0111\u00edch v\u00e0 t\u00ecnh hu\u1ed1ng s\u1eed d\u1ee5ng ri\u00eang. M\u1ed7i lo\u1ea1i Index s\u1edf h\u1eefu \u01b0u, nh\u01b0\u1ee3c \u0111i\u1ec3m ri\u00eang v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng \u0111\u1eb7c th\u00f9 truy v\u1ea5n ho\u1eb7c c\u1ea5u tr\u00fac d\u1eef li\u1ec7u c\u1ee5 th\u1ec3. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c lo\u1ea1i Index ph\u1ed5 bi\u1ebfn m\u00e0 c\u00e1c h\u1ec7 qu\u1ea3n tr\u1ecb Database th\u01b0\u1eddng h\u1ed7 tr\u1ee3.<\/strong><\/p>\n\n\n\n

Clustered Index v\u00e0 Non-Clustered Index<\/h3>\n\n\n\n

Clustered Index<\/strong> l\u00e0 lo\u1ea1i ch\u1ec9 m\u1ee5c s\u1eafp x\u1ebfp v\u1eadt l\u00fd d\u1eef li\u1ec7u trong b\u1ea3ng theo th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh l\u00e0m ch\u1ec9 m\u1ee5c. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 m\u1ed7i b\u1ea3ng ch\u1ec9 c\u00f3 th\u1ec3 c\u00f3 m\u1ed9t Clustered Index, v\u00ec d\u1eef li\u1ec7u ch\u1ec9 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo m\u1ed9t c\u00e1ch duy nh\u1ea5t. Clustered Index \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u1ea7n truy v\u1ea5n theo kho\u1ea3ng gi\u00e1 tr\u1ecb ho\u1eb7c s\u1eafp x\u1ebfp d\u1eef li\u1ec7u.<\/p>\n\n\n\n

Ng\u01b0\u1ee3c l\u1ea1i, Non-Clustered Index<\/strong> kh\u00f4ng thay \u0111\u1ed5i th\u1ee9 t\u1ef1 v\u1eadt l\u00fd c\u1ee7a d\u1eef li\u1ec7u trong b\u1ea3ng. Thay v\u00e0o \u0111\u00f3, n\u00f3 t\u1ea1o ra m\u1ed9t c\u1ea5u tr\u00fac ri\u00eang bi\u1ec7t l\u01b0u tr\u1eef c\u00e1c gi\u00e1 tr\u1ecb kh\u00f3a c\u00f9ng v\u1edbi con tr\u1ecf \u0111\u1ebfn v\u1ecb tr\u00ed c\u1ee7a b\u1ea3n ghi t\u01b0\u01a1ng \u1ee9ng trong b\u1ea3ng. M\u1ed9t b\u1ea3ng c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u Non-Clustered Index, v\u00e0 ch\u00fang r\u1ea5t ph\u00f9 h\u1ee3p \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00e1c truy v\u1ea5n theo nhi\u1ec1u c\u1ed9t kh\u00e1c nhau.<\/p>\n\n\n\n

Unique Index, Composite Index, Full-text Index, Bitmap Index<\/h3>\n\n\n\n

Unique Index<\/strong> \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t ho\u1eb7c nh\u00f3m c\u1ed9t \u0111\u01b0\u1ee3c \u0111\u00e1nh Index l\u00e0 duy nh\u1ea5t. N\u00f3 th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng tr\u00ean c\u00e1c tr\u01b0\u1eddng nh\u01b0 email, username, s\u1ed1 CMND, v.v., \u0111\u1ec3 ng\u0103n ch\u1eb7n d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p.<\/p>\n\n\n\n

    \n
  • Composite Index<\/strong> l\u00e0 ch\u1ec9 m\u1ee5c \u0111\u01b0\u1ee3c t\u1ea1o ra t\u1eeb nhi\u1ec1u h\u01a1n m\u1ed9t c\u1ed9t trong b\u1ea3ng. \u0110\u00e2y l\u00e0 l\u1ef1a ch\u1ecdn l\u00fd t\u01b0\u1edfng khi th\u01b0\u1eddng xuy\u00ean truy v\u1ea5n v\u1edbi \u0111i\u1ec1u ki\u1ec7n k\u1ebft h\u1ee3p nhi\u1ec1u c\u1ed9t, gi\u00fap t\u1ed1i \u01b0u h\u00f3a hi\u1ec7u su\u1ea5t \u0111\u00e1ng k\u1ec3 so v\u1edbi vi\u1ec7c d\u00f9ng nhi\u1ec1u ch\u1ec9 m\u1ee5c \u0111\u01a1n l\u1ebb.<\/li>\n\n\n\n
  • Full-text Index<\/strong> \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 ph\u1ee5c v\u1ee5 vi\u1ec7c t\u00ecm ki\u1ebfm to\u00e0n v\u0103n (full-text search), \u0111\u1eb7c bi\u1ec7t hi\u1ec7u qu\u1ea3 v\u1edbi c\u00e1c c\u1ed9t d\u1ea1ng v\u0103n b\u1ea3n d\u00e0i nh\u01b0 m\u00f4 t\u1ea3 s\u1ea3n ph\u1ea9m, n\u1ed9i dung b\u00e0i vi\u1ebft… H\u1ec7 qu\u1ea3n tr\u1ecb Database nh\u01b0 SQL Server ho\u1eb7c MySQL h\u1ed7 tr\u1ee3 lo\u1ea1i Index n\u00e0y cho ph\u00e9p t\u00ecm ki\u1ebfm theo t\u1eeb kh\u00f3a, c\u1ee5m t\u1eeb v\u00e0 h\u1ed7 tr\u1ee3 l\u1ecdc n\u00e2ng cao.<\/li>\n\n\n\n
  • Bitmap Index<\/strong> l\u00e0 lo\u1ea1i ch\u1ec9 m\u1ee5c s\u1eed d\u1ee5ng bit \u0111\u1ec3 bi\u1ec3u di\u1ec5n s\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb trong c\u1ed9t, r\u1ea5t hi\u1ec7u qu\u1ea3 trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p d\u1eef li\u1ec7u c\u00f3 \u00edt gi\u00e1 tr\u1ecb kh\u00e1c nhau (low cardinality), nh\u01b0 gi\u1edbi t\u00ednh, tr\u1ea1ng th\u00e1i, ph\u00e2n lo\u1ea1i,… Bitmap Index th\u01b0\u1eddng d\u00f9ng trong h\u1ec7 th\u1ed1ng kho d\u1eef li\u1ec7u (data warehouse).<\/li>\n<\/ul>\n\n\n\n

    So s\u00e1nh \u01b0u nh\u01b0\u1ee3c \u0111i\u1ec3m c\u1ee7a t\u1eebng lo\u1ea1i Index trong m\u00f4i tr\u01b0\u1eddng Database<\/h3>\n\n\n\n

    M\u1ed7i lo\u1ea1i Index \u0111\u1ec1u c\u00f3 \u01b0u \u0111i\u1ec3m v\u00e0 h\u1ea1n ch\u1ebf ri\u00eang, ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng c\u1ee5 th\u1ec3:<\/p>\n\n\n\n

      \n
    • Clustered Index<\/strong> cho t\u1ed1c \u0111\u1ed9 truy v\u1ea5n r\u1ea5t nhanh v\u1edbi c\u00e1c c\u1ed9t s\u1eafp x\u1ebfp v\u00e0 l\u1ecdc theo th\u1ee9 t\u1ef1, nh\u01b0ng ch\u1ec9 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c m\u1ed9t l\u1ea7n tr\u00ean m\u1ed7i b\u1ea3ng.<\/li>\n\n\n\n
    • Non-Clustered Index<\/strong> linh ho\u1ea1t h\u01a1n v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng nh\u01b0ng s\u1ebd t\u1ed1n th\u00eam kh\u00f4ng gian l\u01b0u tr\u1eef v\u00e0 c\u1ea7n c\u1eadp nh\u1eadt khi d\u1eef li\u1ec7u thay \u0111\u1ed5i.<\/li>\n\n\n\n
    • Unique Index<\/strong> gi\u00fap \u0111\u1ea3m b\u1ea3o t\u00ednh to\u00e0n v\u1eb9n d\u1eef li\u1ec7u, nh\u01b0ng n\u1ebfu d\u00f9ng qu\u00e1 nhi\u1ec1u c\u00f3 th\u1ec3 l\u00e0m ch\u1eadm t\u1ed1c \u0111\u1ed9 ghi d\u1eef li\u1ec7u.<\/li>\n\n\n\n
    • Composite Index<\/strong> t\u1ed1i \u01b0u t\u1ed1t cho truy v\u1ea5n \u0111a c\u1ed9t, nh\u01b0ng ch\u1ec9 hi\u1ec7u qu\u1ea3 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n truy v\u1ea5n tr\u00f9ng kh\u1edbp v\u1edbi th\u1ee9 t\u1ef1 c\u00e1c c\u1ed9t trong ch\u1ec9 m\u1ee5c.<\/li>\n\n\n\n
    • Full-text Index<\/strong> r\u1ea5t m\u1ea1nh khi l\u00e0m vi\u1ec7c v\u1edbi v\u0103n b\u1ea3n d\u00e0i, nh\u01b0ng c\u00f3 chi ph\u00ed cao v\u1ec1 l\u01b0u tr\u1eef v\u00e0 c\u1ea7n thi\u1ebft l\u1eadp th\u00eam.<\/li>\n\n\n\n
    • Bitmap Index<\/strong> ph\u00f9 h\u1ee3p v\u1edbi truy v\u1ea5n logic \u0111\u01a1n gi\u1ea3n trong kho d\u1eef li\u1ec7u, nh\u01b0ng kh\u00f4ng th\u00edch h\u1ee3p v\u1edbi h\u1ec7 th\u1ed1ng th\u01b0\u1eddng xuy\u00ean c\u1eadp nh\u1eadt.<\/li>\n<\/ul>\n\n\n\n

      Hi\u1ec3u r\u00f5 t\u1eebng lo\u1ea1i Index v\u00e0 \u1ee9ng d\u1ee5ng ph\u00f9 h\u1ee3p s\u1ebd gi\u00fap b\u1ea1n t\u1ed1i \u01b0u h\u00f3a hi\u1ec7u qu\u1ea3 ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch r\u00f5 r\u1ec7t.<\/p>\n\n\n\n

      \u01afu \u0111i\u1ec3m v\u00e0 nh\u01b0\u1ee3c \u0111i\u1ec3m s\u1eed d\u1ee5ng Index trong Database<\/h2>\n\n\n\n

      D\u00f9 Index l\u00e0 c\u00f4ng c\u1ee5 quan tr\u1ecdng gi\u00fap t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t c\u01a1 s\u1edf d\u1eef li\u1ec7u, nh\u01b0ng vi\u1ec7c s\u1eed d\u1ee5ng kh\u00f4ng h\u1ee3p l\u00fd c\u0169ng c\u00f3 th\u1ec3 g\u00e2y \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn hi\u1ec7u n\u0103ng t\u1ed5ng th\u1ec3. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 ph\u00e2n t\u00edch c\u1ee5 th\u1ec3 v\u1ec1 nh\u1eefng \u01b0u v\u00e0 nh\u01b0\u1ee3c \u0111i\u1ec3m khi s\u1eed d\u1ee5ng Index trong Database.<\/strong><\/p>\n\n\n\n

      \u01afu \u0111i\u1ec3m s\u1eed d\u1ee5ng Index trong Database<\/h3>\n\n\n\n

      L\u1ee3i \u00edch r\u00f5 r\u1ec7t nh\u1ea5t c\u1ee7a Index l\u00e0 kh\u1ea3 n\u0103ng t\u0103ng t\u1ed1c \u0111\u1ed9 truy v\u1ea5n d\u1eef li\u1ec7u. Khi m\u1ed9t b\u1ea3ng c\u00f3 Index, h\u1ec7 th\u1ed1ng kh\u00f4ng c\u1ea7n qu\u00e9t to\u00e0n b\u1ed9 d\u1eef li\u1ec7u m\u00e0 ch\u1ec9 tra c\u1ee9u tr\u1ef1c ti\u1ebfp trong c\u1ea5u tr\u00fac ch\u1ec9 m\u1ee5c, t\u1eeb \u0111\u00f3 gi\u00fap truy xu\u1ea5t th\u00f4ng tin nhanh h\u01a1n h\u00e0ng ch\u1ee5c, th\u1eadm ch\u00ed h\u00e0ng tr\u0103m l\u1ea7n. Ngo\u00e0i ra, Index c\u00f2n gi\u00fap gi\u1ea3m t\u1ea3i cho CPU v\u00e0 b\u1ed9 nh\u1edb, \u0111\u1eb7c bi\u1ec7t trong c\u00e1c h\u1ec7 th\u1ed1ng x\u1eed l\u00fd \u0111\u1ed3ng th\u1eddi nhi\u1ec1u truy v\u1ea5n. V\u1edbi c\u00e1c b\u1ea3ng l\u1edbn, vi\u1ec7c s\u1eed d\u1ee5ng Index h\u1ee3p l\u00fd c\u00f3 th\u1ec3 l\u00e0m thay \u0111\u1ed5i to\u00e0n b\u1ed9 hi\u1ec7u su\u1ea5t ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n\n\n\n

      Nh\u01b0\u1ee3c \u0111i\u1ec3m s\u1eed d\u1ee5ng Index trong Database<\/h3>\n\n\n\n

      Tuy mang l\u1ea1i nhi\u1ec1u l\u1ee3i \u00edch trong truy v\u1ea5n, Index c\u0169ng \u0111i k\u00e8m m\u1ed9t s\u1ed1 h\u1ea1n ch\u1ebf \u0111\u00e1ng ch\u00fa \u00fd. Tr\u01b0\u1edbc ti\u00ean, m\u1ed7i Index \u0111\u1ec1u chi\u1ebfm th\u00eam kh\u00f4ng gian l\u01b0u tr\u1eef tr\u00ean \u1ed5 c\u1ee9ng, \u0111\u1eb7c bi\u1ec7t n\u1ebfu b\u1ea3ng c\u00f3 nhi\u1ec1u c\u1ed9t \u0111\u01b0\u1ee3c \u0111\u00e1nh ch\u1ec9 m\u1ee5c ho\u1eb7c d\u00f9ng c\u00e1c lo\u1ea1i Index ph\u1ee9c t\u1ea1p nh\u01b0 Full-text hay Composite. B\u00ean c\u1ea1nh \u0111\u00f3, khi th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c INSERT, UPDATE ho\u1eb7c DELETE, h\u1ec7 th\u1ed1ng ph\u1ea3i c\u1eadp nh\u1eadt c\u1ea3 d\u1eef li\u1ec7u g\u1ed1c v\u00e0 c\u00e1c ch\u1ec9 m\u1ee5c li\u00ean quan, t\u1eeb \u0111\u00f3 l\u00e0m gi\u1ea3m t\u1ed1c \u0111\u1ed9 ghi d\u1eef li\u1ec7u v\u00e0 c\u00f3 th\u1ec3 g\u00e2y ch\u1eadm tr\u1ec5 trong c\u00e1c \u1ee9ng d\u1ee5ng c\u00f3 t\u1ea7n su\u1ea5t c\u1eadp nh\u1eadt cao.<\/p>\n\n\n\n

      C\u00e2n nh\u1eafc th\u1eddi \u0111i\u1ec3m s\u1eed d\u1ee5ng Index trong Database<\/h3>\n\n\n\n

      \u0110\u1ec3 ph\u00e1t huy hi\u1ec7u qu\u1ea3, Index c\u1ea7n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u00fang m\u1ee5c \u0111\u00edch v\u00e0 \u0111\u00fang th\u1eddi \u0111i\u1ec3m. N\u00ean t\u1ea1o Index cho c\u00e1c c\u1ed9t th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c d\u00f9ng trong c\u00e2u l\u1ec7nh WHERE, JOIN, ORDER BY ho\u1eb7c GROUP BY, \u0111\u1eb7c bi\u1ec7t l\u00e0 trong c\u00e1c b\u1ea3ng l\u1edbn. Tuy nhi\u00ean, kh\u00f4ng n\u00ean l\u1ea1m d\u1ee5ng Index, v\u00ec n\u1ebfu t\u1ea1o qu\u00e1 nhi\u1ec1u ch\u1ec9 m\u1ee5c kh\u00f4ng c\u1ea7n thi\u1ebft, h\u1ec7 th\u1ed1ng c\u00f3 th\u1ec3 tr\u1edf n\u00ean c\u1ed3ng k\u1ec1nh, l\u00e0m ch\u1eadm qu\u00e1 tr\u00ecnh ghi d\u1eef li\u1ec7u v\u00e0 g\u00e2y l\u00e3ng ph\u00ed t\u00e0i nguy\u00ean l\u01b0u tr\u1eef. Vi\u1ec7c ph\u00e2n t\u00edch truy v\u1ea5n v\u00e0 ki\u1ec3m tra hi\u1ec7u su\u1ea5t th\u1ef1c t\u1ebf l\u00e0 b\u01b0\u1edbc quan tr\u1ecdng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c n\u00ean Index \u1edf \u0111\u00e2u v\u00e0 nh\u01b0 th\u1ebf n\u00e0o cho ph\u00f9 h\u1ee3p.<\/p>\n\n\n\n

      C\u00e1ch t\u1ea1o v\u00e0 qu\u1ea3n l\u00fd Index trong h\u1ec7 qu\u1ea3n tr\u1ecb Database<\/h2>\n\n\n\n

      \u0110\u1ec3 ph\u00e1t huy t\u1ed1i \u0111a hi\u1ec7u qu\u1ea3 c\u1ee7a Index, vi\u1ec7c t\u1ea1o v\u00e0 qu\u1ea3n l\u00fd ch\u1ec9 m\u1ee5c c\u1ea7n th\u1ef1c hi\u1ec7n \u0111\u00fang c\u00e1ch, ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u truy v\u1ea5n v\u00e0 \u0111\u1eb7c th\u00f9 d\u1eef li\u1ec7u. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c c\u00fa ph\u00e1p c\u01a1 b\u1ea3n v\u00e0 h\u01b0\u1edbng d\u1eabn qu\u1ea3n l\u00fd Index ph\u1ed5 bi\u1ebfn trong c\u00e1c h\u1ec7 qu\u1ea3n tr\u1ecb Database.<\/strong><\/p>\n\n\n\n

      C\u00fa ph\u00e1p t\u1ea1o Index trong c\u00e1c h\u1ec7 qu\u1ea3n tr\u1ecb Database ph\u1ed5 bi\u1ebfn<\/h3>\n\n\n\n

      H\u1ea7u h\u1ebft c\u00e1c h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u hi\u1ec7n nay nh\u01b0 MySQL, PostgreSQL hay SQL Server \u0111\u1ec1u h\u1ed7 tr\u1ee3 c\u00e2u l\u1ec7nh SQL ti\u00eau chu\u1ea9n \u0111\u1ec3 t\u1ea1o Index. C\u00fa ph\u00e1p c\u01a1 b\u1ea3n nh\u01b0 sau:<\/p>\n\n\n\n

      MySQL \/ PostgreSQL:<\/strong><\/p>\n\n\n\n

      sql<\/p>\n\n\n\n

      CopyEdit<\/p>\n\n\n\n

      CREATE INDEX index_ten ON ten_bang(ten_cot);<\/p>\n\n\n\n

      SQL Server:<\/strong><\/p>\n\n\n\n

      sql<\/p>\n\n\n\n

      CopyEdit<\/p>\n\n\n\n

      CREATE INDEX index_ten ON ten_bang(ten_cot);<\/p>\n\n\n\n

      V\u00ed d\u1ee5, \u0111\u1ec3 t\u1ea1o m\u1ed9t Index tr\u00ean c\u1ed9t email c\u1ee7a b\u1ea3ng NguoiDung, ta d\u00f9ng:<\/p>\n\n\n\n

      sql<\/p>\n\n\n\n

      CopyEdit<\/p>\n\n\n\n

      CREATE INDEX idx_email ON NguoiDung(email);<\/p>\n\n\n\n

      Ngo\u00e0i ra, c\u00f3 th\u1ec3 th\u00eam t\u1eeb kh\u00f3a UNIQUE \u0111\u1ec3 t\u1ea1o ch\u1ec9 m\u1ee5c duy nh\u1ea5t, ho\u1eb7c ch\u1ec9 \u0111\u1ecbnh lo\u1ea1i Index nh\u01b0 BTREE, HASH t\u00f9y v\u00e0o h\u1ec7 qu\u1ea3n tr\u1ecb c\u1ee5 th\u1ec3.<\/p>\n\n\n\n

      H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 ki\u1ec3m tra v\u00e0 t\u1ed1i \u01b0u Index trong Database<\/h3>\n\n\n\n

      \u0110\u1ec3 qu\u1ea3n l\u00fd hi\u1ec7u qu\u1ea3 h\u1ec7 th\u1ed1ng Index, c\u00e1c DBA (Database Administrator) th\u01b0\u1eddng s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 \u0111i k\u00e8m v\u1edbi h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u. M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 ph\u1ed5 bi\u1ebfn g\u1ed3m:<\/p>\n\n\n\n

        \n
      • MySQL Workbench<\/strong>: h\u1ed7 tr\u1ee3 ki\u1ec3m tra, t\u1ea1o m\u1edbi, x\u00f3a v\u00e0 ph\u00e2n t\u00edch hi\u1ec7u su\u1ea5t Index tr\u1ef1c quan.<\/li>\n\n\n\n
      • pgAdmin (PostgreSQL)<\/strong>: cung c\u1ea5p th\u00f4ng tin th\u1ed1ng k\u00ea truy v\u1ea5n v\u00e0 Index qua m\u1ee5c Query Tool v\u00e0 Explain Analyze.<\/li>\n\n\n\n
      • SQL Server Management Studio (SSMS)<\/strong>: c\u00f3 t\u00ednh n\u0103ng Database Tuning Advisor gi\u00fap \u0111\u1ec1 xu\u1ea5t Index ph\u00f9 h\u1ee3p d\u1ef1a tr\u00ean l\u1ecbch s\u1eed truy v\u1ea5n.<\/li>\n<\/ul>\n\n\n\n

        Ngo\u00e0i ra, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh nh\u01b0 EXPLAIN, SHOW INDEXES ho\u1eb7c ANALYZE \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ch\u1ec9 m\u1ee5c n\u00e0o \u0111ang \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u00e0 hi\u1ec7u qu\u1ea3 ra sao trong qu\u00e1 tr\u00ecnh th\u1ef1c thi.<\/p>\n\n\n\n

        Th\u1ef1c h\u00e0nh: v\u00ed d\u1ee5 t\u1ea1o v\u00e0 ph\u00e2n t\u00edch hi\u1ec7u qu\u1ea3 c\u1ee7a Index trong Database<\/h3>\n\n\n\n

        Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng SanPham v\u1edbi h\u00e0ng ch\u1ee5c ngh\u00ecn b\u1ea3n ghi, th\u01b0\u1eddng xuy\u00ean truy v\u1ea5n theo c\u1ed9t DanhMuc. Ban \u0111\u1ea7u, truy v\u1ea5n:<\/p>\n\n\n\n

        sql<\/p>\n\n\n\n

        SELECT * FROM SanPham WHERE DanhMuc = ‘\u0110i\u1ec7n t\u1eed’;<\/p>\n\n\n\n

        c\u00f3 th\u1ec3 m\u1ea5t v\u00e0i gi\u00e2y n\u1ebfu kh\u00f4ng c\u00f3 Index. Tuy nhi\u00ean, sau khi t\u1ea1o Index nh\u01b0 sau:<\/p>\n\n\n\n

        sql<\/p>\n\n\n\n

        CREATE INDEX idx_danhmuc ON SanPham(DanhMuc);<\/p>\n\n\n\n

        v\u00e0 s\u1eed d\u1ee5ng l\u1ec7nh:<\/p>\n\n\n\n

        sql<\/p>\n\n\n\n

        EXPLAIN SELECT * FROM SanPham WHERE DanhMuc = ‘\u0110i\u1ec7n t\u1eed’;<\/p>\n\n\n\n

        b\u1ea1n s\u1ebd th\u1ea5y h\u1ec7 th\u1ed1ng chuy\u1ec3n t\u1eeb table scan<\/strong> sang index seek<\/strong>, gi\u00fap truy v\u1ea5n nhanh h\u01a1n r\u00f5 r\u1ec7t. \u0110\u00e2y l\u00e0 minh ch\u1ee9ng tr\u1ef1c quan cho th\u1ea5y Index c\u00f3 th\u1ec3 c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t truy v\u1ea5n nh\u01b0 th\u1ebf n\u00e0o khi \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u00fang c\u00e1ch.<\/p>\n\n\n\n

        Index l\u00e0 c\u00f4ng c\u1ee5 quan tr\u1ecdng gi\u00fap t\u0103ng t\u1ed1c truy v\u1ea5n, gi\u1ea3m t\u1ea3i h\u1ec7 th\u1ed1ng v\u00e0 n\u00e2ng cao hi\u1ec7u su\u1ea5t c\u01a1 s\u1edf d\u1eef li\u1ec7u. Vi\u1ec7c hi\u1ec3u r\u00f5 Index trong database l\u00e0 g\u00ec<\/strong> kh\u00f4ng ch\u1ec9 gi\u00fap t\u1ed1i \u01b0u ho\u1ea1t \u0111\u1ed9ng truy v\u1ea5n m\u00e0 c\u00f2n h\u1ed7 tr\u1ee3 x\u00e2y d\u1ef1ng h\u1ec7 th\u1ed1ng v\u1eadn h\u00e0nh \u1ed5n \u0111\u1ecbnh v\u00e0 hi\u1ec7u qu\u1ea3. \u0110\u1ec3 s\u1eed d\u1ee5ng Index hi\u1ec7u qu\u1ea3, ng\u01b0\u1eddi qu\u1ea3n tr\u1ecb c\u1ea7n x\u00e1c \u0111\u1ecbnh \u0111\u00fang c\u1ed9t c\u1ea7n \u0111\u00e1nh ch\u1ec9 m\u1ee5c, tr\u00e1nh l\u1ea1m d\u1ee5ng g\u00e2y l\u00e3ng ph\u00ed t\u00e0i nguy\u00ean, \u0111\u1ed3ng th\u1eddi th\u01b0\u1eddng xuy\u00ean theo d\u00f5i v\u00e0 \u0111i\u1ec1u ch\u1ec9nh ph\u00f9 h\u1ee3p v\u1edbi h\u00e0nh vi truy v\u1ea5n th\u1ef1c t\u1ebf. Khi \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng h\u1ee3p l\u00fd, Index s\u1ebd g\u00f3p ph\u1ea7n quan tr\u1ecdng trong vi\u1ec7c t\u1ea1o n\u00ean m\u1ed9t h\u1ec7 th\u1ed1ng d\u1eef li\u1ec7u m\u1ea1nh m\u1ebd, linh ho\u1ea1t v\u00e0 d\u1ec5 b\u1ea3o tr\u00ec.<\/p>\n\n\n\n

        Tr\u00ed Nh\u00e2n<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

        C\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng trong vi\u1ec7c l\u01b0u tr\u1eef v\u00e0 qu\u1ea3n l\u00fd th\u00f4ng tin cho h\u1ea7u h\u1ebft c\u00e1c \u1ee9ng d\u1ee5ng c\u00f4ng …<\/p>\n","protected":false},"author":58,"featured_media":9369,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[64],"class_list":["post-9367","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tu-van-nghe-nghiep","tag-it"],"_links":{"self":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/9367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/users\/58"}],"replies":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/comments?post=9367"}],"version-history":[{"count":2,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/9367\/revisions"}],"predecessor-version":[{"id":9373,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/9367\/revisions\/9373"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media\/9369"}],"wp:attachment":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media?parent=9367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/categories?post=9367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/tags?post=9367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}