Other hints provide guidance to the query optimizer regarding when to use indexes to search within tables and the cardinality (the number of rows) of certain tables or intermediate result sets.
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/other-hints/other-hints","slug":"/sql/hints/other-hints/other-hints","pageMetadata":{"title":"Other hints","description":null,"href":"/sql/hints/other-hints/other-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:`Other hints provide guidance to the query optimizer regarding when to use indexes to search within tables and the cardinality (the number of rows) of certain tables or intermediate result sets.`})}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":"Other hints","description":null,"href":"/sql/hints/other-hints/other-hints"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"subdomain":"regatta","siteName":"Regatta","title":"Other hints - Regatta","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-10-07T10:13:17.195Z","originalFileLocation":"sql/hints/other-hints/other-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=\"Other 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/other-hints/other-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=Other+hints\u0026amp;title=Other+hints\u0026amp;theme=acca279d31253fc5f4f921a2\u0026amp;signature=6d4d57c51abfd854ecad00509026ea70c88d0023438f2983300ad33945f8d536\">\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=\"Other hints - Regatta\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://regatta.mintlify.site/_mintlify/api/og/v2?division=Other+hints\u0026amp;title=Other+hints\u0026amp;theme=acca279d31253fc5f4f921a2\u0026amp;signature=6d4d57c51abfd854ecad00509026ea70c88d0023438f2983300ad33945f8d536\">\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/other-hints/other-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/other-hints/other-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/other-hints/other-hints#webpage\",\"url\":\"https://docs.regatta.dev/sql/hints/other-hints/other-hints\",\"name\":\"Other hints\",\"dateModified\":\"2026-10-07T10:13:17.195Z\",\"isPartOf\":{\"@id\":\"https://docs.regatta.dev#website\"},\"breadcrumb\":{\"@id\":\"https://docs.regatta.dev/sql/hints/other-hints/other-hints#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.regatta.dev/sql/hints/other-hints/other-hints#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hints\",\"item\":\"https://docs.regatta.dev/sql/hints/overview\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Other hints\",\"item\":\"https://docs.regatta.dev/sql/hints/other-hints/other-hints\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.regatta.dev/sql/hints/other-hints/other-hints#article\",\"headline\":\"Other hints\",\"name\":\"Other hints\",\"url\":\"https://docs.regatta.dev/sql/hints/other-hints/other-hints\",\"mainEntityOfPage\":{\"@id\":\"https://docs.regatta.dev/sql/hints/other-hints/other-hints#webpage\"},\"dateModified\":\"2026-10-07T10:13:17.195Z\",\"publisher\":{\"@id\":\"https://docs.regatta.dev/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.regatta.dev#website\"}}]}\u003c/script>","agentPointerHref":"/sql/hints/other-hints/other-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","href":"/sql/hints/general-notes"},{"group":"Join hints","pages":[{"title":"Join hints","href":"/sql/hints/join-hints/join-hints"},{"title":"Hint - Join direction","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","description":null,"href":"/sql/hints/parallelism/join-distribution"}]},{"group":"Other hints","pages":[{"title":"Other hints","href":"/sql/hints/other-hints/other-hints"},{"title":"Hint - INDEX","description":null,"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":"Other hints - Regatta","buildId":"dpl_Fyv1NbzwP68g2bEH2Roy98uY1zmE","deploymentId":"dpl_Fyv1NbzwP68g2bEH2Roy98uY1zmE","dynamics":[],"chunks":[]}