{"id":77822,"date":"2026-04-17T18:43:50","date_gmt":"2026-04-17T15:43:50","guid":{"rendered":"https:\/\/saudishopper.com.sa\/en\/?p=77822"},"modified":"2026-04-17T18:43:53","modified_gmt":"2026-04-17T15:43:53","slug":"database-indexes-query-performance","status":"publish","type":"post","link":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/","title":{"rendered":"Database Indexes: What You Need to Know About Query Performance"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Database indexes are fundamental to query performance, yet many developers create them without understanding how they work. Similar to an index in a textbook that directs readers to specific pages, a <a href=\"\/category\/computers\/\">database index<\/a> helps the system locate data quickly rather than scanning every row in a table.<\/p><p class=\"wp-block-paragraph\">Without an index, finding a specific record requires a full table scan. The database reads every row sequentially, checking each one until it finds a match. On a table with millions of rows, this approach becomes problematic. With an index in place, the database can use binary search to locate data far more efficiently, typically stored as a B-tree structure that keeps data sorted and searchable.<\/p><h2 class=\"wp-block-heading\">The Trade-offs of Database Indexes<\/h2><p class=\"wp-block-paragraph\">While indexes accelerate read operations, they introduce costs elsewhere. Every INSERT, UPDATE, or DELETE operation must also update the index, slowing write performance. Additionally, indexes consume disk space and memory. A table with eight indexes requires maintaining nine separate data structures rather than one, increasing cache pressure and storage requirements.<\/p><p class=\"wp-block-paragraph\">The query planner also faces increased complexity. With more indexes available, the planner must evaluate more options to determine the cheapest execution path. On simple queries, planning time can exceed execution time, negating any performance benefit.<\/p><h2 class=\"wp-block-heading\">Common Index Pitfalls and Solutions<\/h2><p class=\"wp-block-paragraph\">Composite indexes require careful consideration of column order. An index on (type_1, type_2) optimizes queries filtering by type_1 alone or both columns together, but queries filtering only by type_2 cannot use the index effectively. The database sorts first by type_1, then by type_2 within each group, leaving type_2 values scattered across the structure.<\/p><p class=\"wp-block-paragraph\">Functions applied to indexed columns also defeat index usage. A query using lower(name) = &#8216;value&#8217; cannot use an index on the raw name column, because the database sees lower(name) as a completely different expression. The same applies to implicit type conversions. The solution involves creating a functional index on the expression itself: CREATE INDEX ON table (lower(column)).<\/p><h2 class=\"wp-block-heading\">Advanced Index Types Worth Knowing<\/h2><p class=\"wp-block-paragraph\">Beyond basic single-column and composite indexes, several specialized types solve specific problems. Functional indexes, discussed above, index the result of an expression rather than raw column values. Partial indexes cover only rows matching a condition, reducing storage and write costs when queries target a small subset of data.<\/p><p class=\"wp-block-paragraph\">Covering indexes contain all columns a query needs, allowing the database to answer the query from the index alone without accessing the table. When viewed with EXPLAIN, this appears as an Index Only Scan. Postgres supports the INCLUDE clause to add non-key columns to an index for covering purposes without forcing the database to sort by those columns.<\/p><h2 class=\"wp-block-heading\">Measuring Index Effectiveness<\/h2><p class=\"wp-block-paragraph\">Rather than guessing whether an index helps, measure actual performance using database tools. Postgres provides EXPLAIN, which shows the query plan without executing it. An Index Scan indicates the index is being used; a Seq Scan means the database is reading every row. EXPLAIN ANALYZE actually runs the query and reports real timings, often revealing surprising results about query behavior.<\/p><p class=\"wp-block-paragraph\">Intelligent indexing directly impacts <a href=\"\/category\/economy\/\">database performance<\/a> and application responsiveness. Understanding index mechanics, trade-offs, and common pitfalls enables developers to make informed decisions rather than creating indexes reactively or leaving them off entirely. Testing with EXPLAIN before deploying indexes to production prevents wasted resources and ensures optimal query execution.<\/p>\n\n\n<p class=\"article-source-attribution wp-block-paragraph\"><em>Source: <a href=\"https:\/\/jon.chrt.dev\/2026\/04\/15\/things-you-didnt-know-about-indexes.html?utm_source=tldrdev\" target=\"_blank\" rel=\"nofollow noopener\">jon.chrt.dev<\/a><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database indexes accelerate queries but introduce trade-offs in write performance and storage. Understanding index mechanics, composite index ordering, functional indexes, and measurement techniques prevents common pitfalls.<\/p>\n","protected":false},"author":10,"featured_media":77821,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_meta-robots-noindex":"","_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_pr_autopilot_social_copy":"{\"x_hook\":\"Database indexes can make or break your application's performance. But creating them without understanding trade-offs and common pitfalls can backfire. Here's what developers need to know.\",\"x_takeaways\":\"Key Highlights:\\n\ud83d\udd39 Indexes speed up reads but slow down writes and consume storage space\\n\ud83d\udd39 Composite index column order matters; queries on later columns won't use the index\\n\ud83d\udd39 Functions wrapping columns defeat indexes; use functional indexes instead\"}","_yoast_wpseo_opengraph_title":"Database Indexes: What You Need to Know About Query Performance","_yoast_wpseo_opengraph_description":"Database indexes are fundamental to query performance. This guide covers how indexes work, their costs, common pitfalls like composite index ordering and function wrapping, and advanced index types including functional, partial, and covering indexes.","_yoast_wpseo_opengraph_image":"https:\/\/saudishopper.com.sa\/en\/wp-content\/uploads\/2026\/04\/database-indexes-btree-structure.webp","_yoast_wpseo_opengraph_image_id":77821,"_yoast_wpseo_twitter_title":"Database Indexes: Query Performance Guide","_yoast_wpseo_twitter_description":"Learn how database indexes work and why they matter. Discover trade-offs, common pitfalls with composite indexes and functions, and advanced index types for optimal performance.","_yoast_wpseo_twitter_image":"https:\/\/saudishopper.com.sa\/en\/wp-content\/uploads\/2026\/04\/database-indexes-btree-structure.webp","_yoast_wpseo_twitter_image_id":77821,"_yoast_wpseo_primary_category":446,"_extra_hide_author_box":"","_extra_featured_post":"","_partner_post_id":107236,"footnotes":""},"categories":[442,446],"tags":[3464,3466,3465],"class_list":["post-77822","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apps","category-computers","tag-database-performance","tag-query-planning","tag-sql-optimization","et-has-post-format-content","et_post_format-et-post-format-standard"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Database Indexes - Query Performance Guide | Saudi Shopper<\/title>\n<meta name=\"description\" content=\"Learn how database indexes work, their trade-offs, and common pitfalls. Discover functional indexes, partial indexes, and covering indexes for optimal query performance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Indexes - Query Performance Guide | Saudi Shopper\" \/>\n<meta property=\"og:description\" content=\"Learn how database indexes work, their trade-offs, and common pitfalls. Discover functional indexes, partial indexes, and covering indexes for optimal query performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/\" \/>\n<meta property=\"og:site_name\" content=\"Saudishopper\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SaudiShopper\" \/>\n<meta property=\"article:published_time\" content=\"2026-04-17T15:43:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-17T15:43:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/saudishopper.com.sa\/en\/wp-content\/uploads\/2026\/04\/database-indexes-btree-structure.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Mohamed Mosaed\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ssict\" \/>\n<meta name=\"twitter:site\" content=\"@ssict\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mohamed Mosaed\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/database-indexes-query-performance\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/database-indexes-query-performance\\\/\"},\"author\":{\"name\":\"Mohamed Mosaed\",\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/#\\\/schema\\\/person\\\/5fe548d4036e285c8f42cdf056399432\"},\"headline\":\"Database Indexes: What You Need to Know About Query Performance\",\"datePublished\":\"2026-04-17T15:43:50+00:00\",\"dateModified\":\"2026-04-17T15:43:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/database-indexes-query-performance\\\/\"},\"wordCount\":557,\"publisher\":{\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/database-indexes-query-performance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/database-indexes-btree-structure.webp\",\"keywords\":[\"database performance\",\"query planning\",\"SQL optimization\"],\"articleSection\":[\"Apps &amp; Software\",\"Computers &amp; Laptops\"],\"inLanguage\":\"en-US\",\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/database-indexes-query-performance\\\/\",\"url\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/database-indexes-query-performance\\\/\",\"name\":\"Database Indexes - Query Performance Guide | Saudi Shopper\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/database-indexes-query-performance\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/database-indexes-query-performance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/database-indexes-btree-structure.webp\",\"datePublished\":\"2026-04-17T15:43:50+00:00\",\"dateModified\":\"2026-04-17T15:43:53+00:00\",\"description\":\"Learn how database indexes work, their trade-offs, and common pitfalls. Discover functional indexes, partial indexes, and covering indexes for optimal query performance.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/database-indexes-query-performance\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/database-indexes-query-performance\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/database-indexes-query-performance\\\/#primaryimage\",\"url\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/database-indexes-btree-structure.webp\",\"contentUrl\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/database-indexes-btree-structure.webp\",\"width\":1200,\"height\":628,\"caption\":\"Database indexes visualization showing B-tree structure and indexed search performance comparison\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/database-indexes-query-performance\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Indexes: What You Need to Know About Query Performance\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/\",\"name\":\"Saudishopper\",\"description\":\"Saudi ICT Shopper News\",\"publisher\":{\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/#organization\",\"name\":\"Saudi ICT News\",\"alternateName\":\"Saudi ICT Shopper News\",\"url\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/SSTrans.png\",\"contentUrl\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/SSTrans.png\",\"width\":423,\"height\":165,\"caption\":\"Saudi ICT News\"},\"image\":{\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/SaudiShopper\",\"https:\\\/\\\/x.com\\\/ssict\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/#\\\/schema\\\/person\\\/5fe548d4036e285c8f42cdf056399432\",\"name\":\"Mohamed Mosaed\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/296c85262ff2745e244f25d889d8abed1b6edd88b3406e359bb0babb74de8fdb?s=96&d=https%3A%2F%2Fsaudishopper.com.sa%2Fen%2Fwp-content%2Fuploads%2F2020%2F12%2Fcropped-ss-icon--150x150.png&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/296c85262ff2745e244f25d889d8abed1b6edd88b3406e359bb0babb74de8fdb?s=96&d=https%3A%2F%2Fsaudishopper.com.sa%2Fen%2Fwp-content%2Fuploads%2F2020%2F12%2Fcropped-ss-icon--150x150.png&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/296c85262ff2745e244f25d889d8abed1b6edd88b3406e359bb0babb74de8fdb?s=96&d=https%3A%2F%2Fsaudishopper.com.sa%2Fen%2Fwp-content%2Fuploads%2F2020%2F12%2Fcropped-ss-icon--150x150.png&r=g\",\"caption\":\"Mohamed Mosaed\"},\"url\":\"https:\\\/\\\/saudishopper.com.sa\\\/en\\\/author\\\/mmosaed\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database Indexes - Query Performance Guide | Saudi Shopper","description":"Learn how database indexes work, their trade-offs, and common pitfalls. Discover functional indexes, partial indexes, and covering indexes for optimal query performance.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/","og_locale":"en_US","og_type":"article","og_title":"Database Indexes - Query Performance Guide | Saudi Shopper","og_description":"Learn how database indexes work, their trade-offs, and common pitfalls. Discover functional indexes, partial indexes, and covering indexes for optimal query performance.","og_url":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/","og_site_name":"Saudishopper","article_publisher":"https:\/\/www.facebook.com\/SaudiShopper","article_published_time":"2026-04-17T15:43:50+00:00","article_modified_time":"2026-04-17T15:43:53+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/saudishopper.com.sa\/en\/wp-content\/uploads\/2026\/04\/database-indexes-btree-structure.webp","type":"image\/webp"}],"author":"Mohamed Mosaed","twitter_card":"summary_large_image","twitter_creator":"@ssict","twitter_site":"@ssict","twitter_misc":{"Written by":"Mohamed Mosaed","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/#article","isPartOf":{"@id":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/"},"author":{"name":"Mohamed Mosaed","@id":"https:\/\/saudishopper.com.sa\/en\/#\/schema\/person\/5fe548d4036e285c8f42cdf056399432"},"headline":"Database Indexes: What You Need to Know About Query Performance","datePublished":"2026-04-17T15:43:50+00:00","dateModified":"2026-04-17T15:43:53+00:00","mainEntityOfPage":{"@id":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/"},"wordCount":557,"publisher":{"@id":"https:\/\/saudishopper.com.sa\/en\/#organization"},"image":{"@id":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/saudishopper.com.sa\/en\/wp-content\/uploads\/2026\/04\/database-indexes-btree-structure.webp","keywords":["database performance","query planning","SQL optimization"],"articleSection":["Apps &amp; Software","Computers &amp; Laptops"],"inLanguage":"en-US","copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/saudishopper.com.sa\/en\/#organization"}},{"@type":"WebPage","@id":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/","url":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/","name":"Database Indexes - Query Performance Guide | Saudi Shopper","isPartOf":{"@id":"https:\/\/saudishopper.com.sa\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/#primaryimage"},"image":{"@id":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/saudishopper.com.sa\/en\/wp-content\/uploads\/2026\/04\/database-indexes-btree-structure.webp","datePublished":"2026-04-17T15:43:50+00:00","dateModified":"2026-04-17T15:43:53+00:00","description":"Learn how database indexes work, their trade-offs, and common pitfalls. Discover functional indexes, partial indexes, and covering indexes for optimal query performance.","breadcrumb":{"@id":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/#primaryimage","url":"https:\/\/saudishopper.com.sa\/en\/wp-content\/uploads\/2026\/04\/database-indexes-btree-structure.webp","contentUrl":"https:\/\/saudishopper.com.sa\/en\/wp-content\/uploads\/2026\/04\/database-indexes-btree-structure.webp","width":1200,"height":628,"caption":"Database indexes visualization showing B-tree structure and indexed search performance comparison"},{"@type":"BreadcrumbList","@id":"https:\/\/saudishopper.com.sa\/en\/database-indexes-query-performance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/saudishopper.com.sa\/en\/"},{"@type":"ListItem","position":2,"name":"Database Indexes: What You Need to Know About Query Performance"}]},{"@type":"WebSite","@id":"https:\/\/saudishopper.com.sa\/en\/#website","url":"https:\/\/saudishopper.com.sa\/en\/","name":"Saudishopper","description":"Saudi ICT Shopper News","publisher":{"@id":"https:\/\/saudishopper.com.sa\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/saudishopper.com.sa\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/saudishopper.com.sa\/en\/#organization","name":"Saudi ICT News","alternateName":"Saudi ICT Shopper News","url":"https:\/\/saudishopper.com.sa\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/saudishopper.com.sa\/en\/#\/schema\/logo\/image\/","url":"https:\/\/saudishopper.com.sa\/en\/wp-content\/uploads\/2020\/08\/SSTrans.png","contentUrl":"https:\/\/saudishopper.com.sa\/en\/wp-content\/uploads\/2020\/08\/SSTrans.png","width":423,"height":165,"caption":"Saudi ICT News"},"image":{"@id":"https:\/\/saudishopper.com.sa\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SaudiShopper","https:\/\/x.com\/ssict"]},{"@type":"Person","@id":"https:\/\/saudishopper.com.sa\/en\/#\/schema\/person\/5fe548d4036e285c8f42cdf056399432","name":"Mohamed Mosaed","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/296c85262ff2745e244f25d889d8abed1b6edd88b3406e359bb0babb74de8fdb?s=96&d=https%3A%2F%2Fsaudishopper.com.sa%2Fen%2Fwp-content%2Fuploads%2F2020%2F12%2Fcropped-ss-icon--150x150.png&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/296c85262ff2745e244f25d889d8abed1b6edd88b3406e359bb0babb74de8fdb?s=96&d=https%3A%2F%2Fsaudishopper.com.sa%2Fen%2Fwp-content%2Fuploads%2F2020%2F12%2Fcropped-ss-icon--150x150.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/296c85262ff2745e244f25d889d8abed1b6edd88b3406e359bb0babb74de8fdb?s=96&d=https%3A%2F%2Fsaudishopper.com.sa%2Fen%2Fwp-content%2Fuploads%2F2020%2F12%2Fcropped-ss-icon--150x150.png&r=g","caption":"Mohamed Mosaed"},"url":"https:\/\/saudishopper.com.sa\/en\/author\/mmosaed\/"}]}},"_links":{"self":[{"href":"https:\/\/saudishopper.com.sa\/en\/wp-json\/wp\/v2\/posts\/77822","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saudishopper.com.sa\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saudishopper.com.sa\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saudishopper.com.sa\/en\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/saudishopper.com.sa\/en\/wp-json\/wp\/v2\/comments?post=77822"}],"version-history":[{"count":1,"href":"https:\/\/saudishopper.com.sa\/en\/wp-json\/wp\/v2\/posts\/77822\/revisions"}],"predecessor-version":[{"id":77823,"href":"https:\/\/saudishopper.com.sa\/en\/wp-json\/wp\/v2\/posts\/77822\/revisions\/77823"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/saudishopper.com.sa\/en\/wp-json\/wp\/v2\/media\/77821"}],"wp:attachment":[{"href":"https:\/\/saudishopper.com.sa\/en\/wp-json\/wp\/v2\/media?parent=77822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saudishopper.com.sa\/en\/wp-json\/wp\/v2\/categories?post=77822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saudishopper.com.sa\/en\/wp-json\/wp\/v2\/tags?post=77822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}