Join hints can be applied only to explicit joins. In order to use join hints, the join result must be aliased and the alias name specified in the hint to identify the join.
Was this page helpful?
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Regatta","colors":{"primary":"#ff6600","light":"#FF6600","dark":"#ff6600"},"logo":{"light":"https://mintcdn.com/regatta/HR4-Kyi3p6WFSWx7/logo/Regatta_Logo_Colors_Black_RGB_1.svg?fit=max\u0026auto=format\u0026n=HR4-Kyi3p6WFSWx7\u0026q=85\u0026s=80ecf4af831aaabfecd51ca1c1dab7a7","dark":"https://mintcdn.com/regatta/HR4-Kyi3p6WFSWx7/logo/Regatta_Logo_Colors_White_RGB_1.svg?fit=max\u0026auto=format\u0026n=HR4-Kyi3p6WFSWx7\u0026q=85\u0026s=1be4bc683939b389d14aa1eeda3216d9"},"favicon":"https://mintcdn.com/regatta/xrn8wIqTNfsgHe4O/images/favicon.svg?fit=max\u0026auto=format\u0026n=xrn8wIqTNfsgHe4O\u0026q=85\u0026s=c025dcbef503c87e965049f809c4a3c4","background":{"color":{"light":"#f7f8fa","dark":"#041225"}},"navbar":{"links":[{"href":"https://rdbproject.atlassian.net/servicedesk/customer/portals","label":"Support"}],"primary":{"type":"button","label":"Start Coding","href":"https://regatta.dev/"}},"footer":{"socials":{"x":"https://twitter.com/regatta_data","linkedin":"https://www.linkedin.com/company/regatta-data"}},"fonts":{"family":"Inter"},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"regatta","hasAudioNarration":false,"actualSubdomain":"regatta","customDomains":["docs.regatta.dev"],"gitSource":{"type":"github","owner":"regattadata","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"feedback":{"thumbs":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"REMOVE_BRANDING":{"status":"ENABLED"},"CONTEXTUAL_FEEDBACK":{"status":"ENABLED"},"CODE_SNIPPET_FEEDBACK":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af9b9685a8e334304f95aa9","clientVersion":"0.0.4143","searchFilterCounts":[{"language":"default","tag":"SQL","count":84},{"language":"default","tag":"Self-Hosted Deployment","count":38},{"language":"default","tag":"Tuning Performance","count":20},{"language":"default","tag":"Regatta Deployment Tool","count":19},{"language":"default","tag":"Quickstart","count":18},{"language":"default","tag":"System Monitoring","count":18},{"language":"default","tag":"Drivers \u0026 Clients","count":16},{"language":"default","tag":"SQL Functions and Operators","count":15},{"language":"default","tag":"Kubernetes Deployment","count":13},{"language":"default","tag":"Hints","count":12}]},"assistantConfig":{},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"body::-webkit-scrollbar{width:5px}body::-webkit-scrollbar-thumb{background-color:#888;border-radius:10px}body::-webkit-scrollbar-track{background-color:#f1f1f1}#sidebar-content::-webkit-scrollbar{display:none}table td:first-child,table th:first-child{max-width:16rem}table code{white-space:normal;overflow-wrap:break-word;word-break:break-word}"}],"page":{"pagePath":"sql/hints/join-hints/join-hints","slug":"/sql/hints/join-hints/join-hints","pageMetadata":{"title":"Join hints","description":null,"href":"/sql/hints/join-hints/join-hints"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{jsx:_jsx}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={p:`p`,..._provideComponents(),...props.components};return _jsx(_components.p,{children:`Join hints can be applied only to explicit joins. In order to use join hints, the join result must be aliased and the alias name specified in the hint to identify the join.`})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Join hints","description":null,"href":"/sql/hints/join-hints/join-hints"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"subdomain":"regatta","siteName":"Regatta","title":"Join hints - Regatta","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-10-07T10:13:17.191Z","originalFileLocation":"sql/hints/join-hints/join-hints.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"application-name\" content=\"Regatta\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Join hints - Regatta\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Regatta\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.regatta.dev/sql/hints/join-hints/join-hints\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://regatta.mintlify.site/_mintlify/api/og/v2?division=Join+hints\u0026amp;title=Join+hints\u0026amp;theme=acca279d31253fc5f4f921a2\u0026amp;signature=523ea13e8d13f926e74071b7c2a2774f294117ebdb55086331c47e08def9ac56\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Join hints - Regatta\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://regatta.mintlify.site/_mintlify/api/og/v2?division=Join+hints\u0026amp;title=Join+hints\u0026amp;theme=acca279d31253fc5f4f921a2\u0026amp;signature=523ea13e8d13f926e74071b7c2a2774f294117ebdb55086331c47e08def9ac56\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Regatta\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#ff6600\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.regatta.dev/sql/hints/join-hints/join-hints\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/sql/hints/join-hints/join-hints.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.regatta.dev/#organization\",\"name\":\"Regatta\",\"url\":\"https://docs.regatta.dev\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/regatta/HR4-Kyi3p6WFSWx7/logo/Regatta_Logo_Colors_Black_RGB_1.svg?fit=max\u0026auto=format\u0026n=HR4-Kyi3p6WFSWx7\u0026q=85\u0026s=80ecf4af831aaabfecd51ca1c1dab7a7\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.regatta.dev#website\",\"name\":\"Regatta\",\"url\":\"https://docs.regatta.dev\",\"publisher\":{\"@id\":\"https://docs.regatta.dev/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.regatta.dev/sql/hints/join-hints/join-hints#webpage\",\"url\":\"https://docs.regatta.dev/sql/hints/join-hints/join-hints\",\"name\":\"Join hints\",\"dateModified\":\"2026-10-07T10:13:17.191Z\",\"isPartOf\":{\"@id\":\"https://docs.regatta.dev#website\"},\"breadcrumb\":{\"@id\":\"https://docs.regatta.dev/sql/hints/join-hints/join-hints#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.regatta.dev/sql/hints/join-hints/join-hints#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hints\",\"item\":\"https://docs.regatta.dev/sql/hints/overview\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Join hints\",\"item\":\"https://docs.regatta.dev/sql/hints/join-hints/join-hints\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.regatta.dev/sql/hints/join-hints/join-hints#article\",\"headline\":\"Join hints\",\"name\":\"Join hints\",\"url\":\"https://docs.regatta.dev/sql/hints/join-hints/join-hints\",\"mainEntityOfPage\":{\"@id\":\"https://docs.regatta.dev/sql/hints/join-hints/join-hints#webpage\"},\"dateModified\":\"2026-10-07T10:13:17.191Z\",\"publisher\":{\"@id\":\"https://docs.regatta.dev/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.regatta.dev#website\"}}]}\u003c/script>","agentPointerHref":"/sql/hints/join-hints/join-hints.md","siteName":"Regatta","nav":{"global":null,"anchors":[{"anchor":"Docs Home","icon":"house","pages":[{"title":"Docs Home","href":"/home"}]},{"anchor":"Quickstart","pages":[{"title":"Quickstart","href":"/getting-started/getting-started-using-regatta-cloud"}]},{"anchor":"SQL","icon":"code","groups":[{"group":"SQL Specification","pages":[{"title":"Introduction","href":"/sql/introduction"}]},{"group":"SQL Syntax Conventions","pages":[{"title":"SQL Syntax Conventions","href":"/sql/sql-syntax-convention"}]},{"group":"Data Types","pages":[{"title":"Introduction","href":"/sql/data-types/introduction"},{"group":"Numeric types","pages":[{"title":"Exact numeric data type","href":"/sql/data-types/numeric-types/exact-numeric-data-type"},{"title":"Approximate numeric data type","href":"/sql/data-types/numeric-types/approximate-numeric-data-type"}]},{"title":"Character types","href":"/sql/data-types/character-types"},{"title":"Date/Time types","href":"/sql/data-types/date-time-types"},{"title":"Boolean types","href":"/sql/data-types/boolean-types"},{"title":"UUID type","href":"/sql/data-types/uuid-type"},{"group":"Type Conversion","pages":[{"title":"Type Conversion","href":"/sql/data-types/type-conversion/type-conversion"},{"title":"Type conversion table","href":"/sql/data-types/type-conversion/type-conversion-table"}]},{"title":"ROW IDs","href":"/sql/data-types/row-ids"}]},{"group":"SQL Functions and Operators","pages":[{"title":"SQL Functions and Operators","href":"/sql/sql-functions-and-operators/sql-functions-and-operators"},{"title":"Comparison Functions and Operators","href":"/sql/sql-functions-and-operators/comparison-function"},{"group":"Mathematical Functions and Operators","pages":[{"title":"Mathematical Functions and Operators","href":"/sql/sql-functions-and-operators/maths-functions-operators/maths-functions-operators"},{"title":"Mathematical Operators","href":"/sql/sql-functions-and-operators/maths-functions-operators/maths-operators"},{"title":"Mathematical Functions","href":"/sql/sql-functions-and-operators/maths-functions-operators/maths-functions"}]},{"title":"String Functions and Operators","href":"/sql/sql-functions-and-operators/string-functions-operators"},{"title":"Date/Time Functions and Operators","href":"/sql/sql-functions-and-operators/date-time-functions-operators/date-time-functions-operators"},{"group":"Conditional Expressions","pages":[{"title":"CASE","href":"/sql/sql-functions-and-operators/conditional-expressions/case"}]},{"group":"Convert Functions","pages":[{"title":"CAST","href":"/sql/sql-functions-and-operators/convert-function/cast"},{"title":"Date and Time Formatting Functions","href":"/sql/sql-functions-and-operators/convert-function/date-time-format-functions"}]},{"group":"Aggregate Functions","pages":[{"title":"Aggregate Functions","href":"/sql/sql-functions-and-operators/aggregate-functions/aggregate-functions"},{"title":"Examples","href":"/sql/sql-functions-and-operators/aggregate-functions/examples"}]},{"group":"Subquery Expressions","pages":[{"title":"Subquery Expressions","href":"/sql/sql-functions-and-operators/subquery-expressions/subquery-expressions"},{"title":"IN and NOT IN","href":"/sql/sql-functions-and-operators/subquery-expressions/not-in/not-in"}]},{"title":"UUID Functions and Operators","href":"/sql/sql-functions-and-operators/untitled-page"}]},{"group":"Data Definition Language (DDL) Commands","pages":[{"title":"CREATE TABLE","href":"/sql/ddl-commands/create-table"},{"title":"ALTER TABLE","href":"/sql/ddl-commands/alter-table"},{"title":"DROP TABLE","href":"/sql/ddl-commands/drop-table"}]},{"group":"Data Manipulation Language Commands","pages":[{"title":"INSERT","href":"/sql/dml-commands/insert"},{"title":"UPDATE","href":"/sql/dml-commands/update"},{"title":"DELETE","href":"/sql/dml-commands/delete"}]},{"group":"Transaction Control Language Commands","pages":[{"title":"Transaction Control Language Commands","href":"/sql/tcl-commands/tcl-commands"},{"title":"SET TRANSACTION","href":"/sql/tcl-commands/set-transaction"}]},{"group":"Data Query Language","pages":[{"title":"SELECT","href":"/sql/dql/select"},{"title":"EXPLAIN","href":"/sql/dql/explain"}]},{"group":"Hints","pages":[{"title":"Overview","href":"/sql/hints/overview"},{"title":"General notes","description":null,"href":"/sql/hints/general-notes"},{"group":"Join hints","pages":[{"title":"Join hints","href":"/sql/hints/join-hints/join-hints"},{"title":"Hint - Join direction","description":null,"href":"/sql/hints/join-hints/join-direction"},{"title":"Hint - Join method","href":"/sql/hints/join-hints/join-method"},{"title":"Hint - Join distribution method","href":"/sql/hints/join-hints/join-distribution"}]},{"group":"Hints for parallelism of distributed operations","pages":[{"title":"Hint for parallelism of distributed operations","href":"/sql/hints/parallelism/hints-for-parallelism"},{"title":"Hint - Distributed Sorting","href":"/sql/hints/parallelism/sorting"},{"title":"Hint - Join distribution","href":"/sql/hints/parallelism/join-distribution"}]},{"group":"Other hints","pages":[{"title":"Other hints","href":"/sql/hints/other-hints/other-hints"},{"title":"Hint - INDEX","href":"/sql/hints/other-hints/hint-index"},{"title":"Hint - Cardinality","href":"/sql/hints/other-hints/hint-cardinality"}]}]},{"group":"Managing Users","pages":[{"title":"CREATE USER","href":"/sql/managing-users/create-user"},{"title":"ALTER USER","href":"/sql/managing-users/alter-user"},{"title":"DROP USER","href":"/sql/managing-users/drop-user"}]},{"group":"System Monitoring","pages":[{"title":"Using System Monitoring Views","href":"/sql/system-monitoring/system-monitoring-views/system-monitoring-views"},{"title":"SHOW SYSTEM VIEWS","href":"/sql/system-monitoring/show-system-views"},{"group":"Database Catalog Data","pages":[{"title":"Database Catalog Data","href":"/sql/system-monitoring/database-catalog/database-catalog"},{"title":"SHOW TABLES","href":"/sql/system-monitoring/database-catalog/show-tables"},{"title":"SHOW TABLE DEVICES","href":"/sql/system-monitoring/database-catalog/show-table-devices"},{"title":"SHOW INDEXES","href":"/sql/system-monitoring/database-catalog/show-index"},{"title":"SHOW INDEX DEVICES","href":"/sql/system-monitoring/database-catalog/show-index-devices"},{"title":"SHOW COLUMNS","href":"/sql/system-monitoring/database-catalog/show-columns"},{"title":"SHOW CONSTRAINTS","href":"/sql/system-monitoring/database-catalog/show-constraints"},{"title":"SHOW USERS","href":"/sql/system-monitoring/database-catalog/show-users"}]},{"group":"System Catalog Data","pages":[{"title":"SHOW NODES","href":"/sql/system-monitoring/system-catalog/show-nodes"},{"title":"SHOW MODULES","href":"/sql/system-monitoring/system-catalog/show-modules"},{"title":"SHOW DEVICES","href":"/sql/system-monitoring/system-catalog/show-devices"}]},{"group":"Dynamic System Data","pages":[{"title":"Dynamic System Data","href":"/sql/system-monitoring/dynamic-system/dynamic-system"},{"title":"SHOW METRIC DESCRIPTION","href":"/sql/system-monitoring/dynamic-system/show-metric-description"},{"title":"SHOW DATABASE METRICS","href":"/sql/system-monitoring/dynamic-system/show-database-metric"},{"title":"SHOW MODULE METRICS","href":"/sql/system-monitoring/dynamic-system/show-module-metrics"},{"title":"SHOW DEVICE METRICS","href":"/sql/system-monitoring/dynamic-system/show-device-metrics"}]}]},{"group":"System Management","pages":[{"title":"System States and Commands","href":"/sql/system-management/system-states-and-commands"},{"title":"Nodes","href":"/sql/system-management/nodes"},{"title":"Modules","href":"/sql/system-management/modules"},{"title":"Storage Devices","href":"/sql/system-management/storage-devices"},{"title":"System Manager","href":"/sql/system-management/system-manager"}]},{"group":"Appendices","pages":[{"title":"Identifiers Limitations","href":"/sql/appendices/indentifiers-limitations"},{"title":"Database Limitations","href":"/sql/appendices/database-limitations"},{"title":"Reserved Words","href":"/sql/appendices/reserved-words"}]},{"group":"Vector Index","pages":[{"title":"Introduction","href":"/sql/vector-index/introduction"},{"group":"DDL","pages":[{"title":"Creating a Vector Index","href":"/sql/vector-index/ddl/creating-vector-index"},{"title":"Deleting a Vector Index","href":"/sql/vector-index/ddl/deleting-vector-index"},{"title":"Modifying a Vector Index","href":"/sql/vector-index/ddl/modifying-vector-index"}]},{"title":"Show Commands","href":"/sql/vector-index/show-commands"},{"title":"Performing Approximate Vector Searches","href":"/sql/vector-index/performing-approximate-vector-searches"}]}]},{"anchor":"Regatta Cloud","icon":"cloud","pages":[{"title":"Regatta Cloud","href":"/regatta-cloud/regatta-cloud/regatta-cloud"}]},{"anchor":"Self-Hosted Deployment","icon":"server","pages":[{"title":"Self-Hosted Deployment","href":"/self-hosted-deployment/prerequisites"}]},{"anchor":"Drivers \u0026 Clients","icon":"download","pages":[{"title":"Drivers \u0026 Clients","href":"/drivers-and-clients/connecting-applications-to-regatta"}]},{"anchor":"Tuning Performance","icon":"rocket","pages":[{"title":"Tuning Performance","href":"/tuning-performance/introduction/introduction"}]}]},"basePath":"","title":"Join hints - Regatta","buildId":"dpl_Fyv1NbzwP68g2bEH2Roy98uY1zmE","deploymentId":"dpl_Fyv1NbzwP68g2bEH2Roy98uY1zmE","dynamics":[],"chunks":[]}