CINXE.COM

<!DOCTYPE html><html lang="en"><head><meta charSet="utf-8"/><title>Flexible Indexing with StarTree Cloud | StarTree</title><meta name="robots" content="index,follow"/><meta name="description" content="Optimize query performance and cost with comprehensive flexible indexing options from StarTree Cloud. Learn more."/><meta property="og:title" content="Flexible Indexing with StarTree Cloud | StarTree"/><meta property="og:description" content="Optimize query performance and cost with comprehensive flexible indexing options from StarTree Cloud. Learn more."/><meta property="og:url" content="https://startree.ai/products/indexing"/><meta property="og:image" content="https://startreecms.wpenginepowered.com/wp-content/uploads/2024/08/Open-Graph.jpg"/><link rel="canonical" href="https://startree.ai/products/indexing"/><meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"/><link rel="apple-touch-icon" sizes="180x180" href="/favicon/apple-touch-icon.png"/><link rel="icon" type="image/png" sizes="32x32" href="/favicon/favicon-32x32.png"/><link rel="icon" type="image/png" sizes="16x16" href="/favicon/favicon-16x16.png"/><link rel="manifest" href="/favicon/site.webmanifest"/><link rel="mask-icon" href="/favicon/safari-pinned-tab.svg" color="#5bbad5"/><meta name="msapplication-TileColor" content="#ffffff"/><meta name="theme-color" content="#ffffff"/><meta name="twitter:card" content="summary"/><meta name="next-head-count" content="18"/><link rel="preload" href="/_next/static/media/f7040064460a9b21-s.p.woff2" as="font" type="font/woff2" crossorigin="anonymous" data-next-font="size-adjust"/><link rel="preload" href="/_next/static/media/122c360d7fe6d395-s.p.woff2" as="font" type="font/woff2" crossorigin="anonymous" data-next-font="size-adjust"/><link rel="preload" href="/_next/static/css/5a8a7083ece16541.css" as="style"/><link rel="stylesheet" href="/_next/static/css/5a8a7083ece16541.css" data-n-g=""/><link rel="preload" href="/_next/static/css/25cae41c71aa3ee0.css" as="style"/><link rel="stylesheet" href="/_next/static/css/25cae41c71aa3ee0.css" data-n-p=""/><noscript data-n-css=""></noscript><script defer="" nomodule="" src="/_next/static/chunks/polyfills-78c92fac7aa8fdd8.js"></script><script id="brightEdge" src="//cdn.bc0a.com/autopilot/f00000000304780/autopilot_sdk.js" data-cfasync="false" defer="" data-nscript="beforeInteractive"></script><script defer="" src="/_next/static/chunks/114.c67adae6ed23d0f1.js"></script><script defer="" src="/_next/static/chunks/442.2c3608a8ab0d9442.js"></script><script src="/_next/static/chunks/webpack-7f5c6789c515ac4f.js" defer=""></script><script src="/_next/static/chunks/framework-9620da855a94eb57.js" defer=""></script><script src="/_next/static/chunks/main-4c5a65bf32bd6706.js" defer=""></script><script src="/_next/static/chunks/pages/_app-af3bd3ce1347445d.js" defer=""></script><script src="/_next/static/chunks/31d4e3d1-0a655c6d6ff6e9de.js" defer=""></script><script src="/_next/static/chunks/9e82d048-ffb998b39e497a2e.js" defer=""></script><script src="/_next/static/chunks/854-338aa8ccdafb1663.js" defer=""></script><script src="/_next/static/chunks/927-252a7a71f883e286.js" defer=""></script><script src="/_next/static/chunks/463-f9292cf30fcf41ef.js" defer=""></script><script src="/_next/static/chunks/726-b42f656bc376bec4.js" defer=""></script><script src="/_next/static/chunks/36-4a2f251bf92c9eff.js" defer=""></script><script src="/_next/static/chunks/pages/%5B...slug%5D-331d80a55f5812e2.js" defer=""></script><script src="/_next/static/5E_oIdejje66pIeqN--KF/_buildManifest.js" defer=""></script><script src="/_next/static/5E_oIdejje66pIeqN--KF/_ssgManifest.js" defer=""></script><style id="__jsx-3450457828">:root{--font-mulish:'__Mulish_1ed915', '__Mulish_Fallback_1ed915';--font-fira:'__Fira_Code_74c79e', '__Fira_Code_Fallback_74c79e'}</style></head><body class="font-body"><div id="__next"><header class="fixed inset-x-0 top-0 z-50 h-[60px] w-full bg-indigo transition-all duration-300 lg:h-[89px] bg-transparent"><div class="header-container h-full"><div class="flex h-full items-center justify-between gap-4"><div class="z-50 flex items-center gap-[71px]"><div class="relative z-50 w-[100px] cursor-pointer lg:w-[118px]"><a aria-label="Back to Home" class="nav-logo transition-colors text-indigo" href="/"><svg width="100%" height="100%" viewBox="0 0 119 21" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M12.65 15.607c0 3.3-2.893 4.893-6.186 4.893-3.078 0-5.357-1.286-6.464-3.64l3.446-1.928c.433 1.257 1.479 1.99 3.018 1.99 1.265 0 2.122-.43 2.122-1.315 0-2.236-7.94-1.01-7.94-6.393 0-3.118 2.679-4.86 5.847-4.86 2.5 0 4.643 1.128 5.846 3.239L8.954 9.429a2.607 2.607 0 0 0-2.465-1.561c-.982 0-1.785.428-1.785 1.257 0 2.26 7.942.854 7.942 6.482M36.785 12.425c0-2.568-1.817-4.31-4.285-4.31s-4.247 1.742-4.247 4.31c0 2.568 1.815 4.311 4.247 4.311s4.285-1.74 4.285-4.31Zm3.972-7.643v15.29h-3.971V18.26c-1.108 1.375-2.772 2.232-5.018 2.232-4.093 0-7.479-3.518-7.479-8.075 0-4.557 3.386-8.071 7.479-8.071 2.246 0 3.91.853 5.017 2.232V4.775l3.972.007ZM51.615 4.475v4.403c-2.06-.243-4.679.675-4.679 3.886v7.307h-3.971V4.781h3.971v2.63c.8-2.08 2.74-2.936 4.679-2.936ZM71.369 8.571v6.361c0 1.654 1.2 1.682 3.475 1.56v3.572c-5.572.611-7.45-1.007-7.45-5.135V8.564h-2.675V4.775h2.675V.489h3.975v4.286h3.475v3.79h-3.475M85.146 4.475v4.403c-2.06-.243-4.675.675-4.675 3.886v7.307H76.5V4.781h3.971v2.63c.797-2.08 2.736-2.936 4.675-2.936ZM97.61 10.99a3.732 3.732 0 0 0-3.817-3.086c-2.121 0-3.571 1.132-4.032 3.09h7.857m-3.45 5.931a4.286 4.286 0 0 0 3.45-1.528l3.214 1.832c-1.428 2.082-3.753 3.275-6.71 3.275-5.168 0-8.433-3.518-8.433-8.075 0-4.557 3.293-8.072 8.126-8.072 4.557 0 7.785 3.572 7.785 8.072a8.821 8.821 0 0 1-.153 1.621H89.822c.553 2.015 2.25 2.872 4.339 2.872l.007.003ZM114.603 10.99a3.733 3.733 0 0 0-3.818-3.086c-2.125 0-3.571 1.132-4.032 3.09h7.857m-3.45 5.931a4.284 4.284 0 0 0 3.45-1.528l3.214 1.832c-1.446 2.082-3.757 3.275-6.71 3.275-5.172 0-8.432-3.518-8.432-8.075 0-4.557 3.292-8.072 8.125-8.072 4.553 0 7.785 3.572 7.785 8.072a8.821 8.821 0 0 1-.153 1.621h-11.625c.557 2.015 2.246 2.872 4.339 2.872l.007.003ZM20.043 8.571v6.361c0 1.654 1.2 1.682 3.479 1.56v3.572c-5.572.611-7.45-1.007-7.45-5.135V8.564h-2.675V4.775h2.675V.489h3.97v4.286h3.48v3.79h-3.48M63.114 10.857h-4.596V4.643a.282.282 0 0 0-.06-.175.304.304 0 0 0-.154-.103.268.268 0 0 0-.183 0 .275.275 0 0 0-.142.117l-5.415 8.958a.333.333 0 0 0-.042.142.297.297 0 0 0 .143.254.311.311 0 0 0 .146.04h4.6v6.217a.286.286 0 0 0 .21.279c.06.018.123.018.183 0a.293.293 0 0 0 .142-.118l5.411-8.957a.26.26 0 0 0 .043-.147.282.282 0 0 0-.143-.25.26.26 0 0 0-.146-.043" fill="currentColor"></path></svg></a></div><nav class="flex items-center gap-8 max-lg:hidden"><a class="nav-link z-50 relative text-indigo" aria-label="Platform" href="/products/startree-cloud"><span style="will-change:opacity">Platform</span></a><button type="button" class="nav-link z-50 relative text-indigo" aria-label="Solutions"><span style="will-change:opacity">Solutions</span></button><a class="nav-link z-50 relative text-indigo" aria-label="For Developers" href="https://dev.startree.ai/"><span style="will-change:opacity">For Developers</span></a><a class="nav-link z-50 relative text-indigo" aria-label="Resources" href="/resources"><span style="will-change:opacity">Resources</span></a><a class="nav-link z-50 relative text-indigo" href="/partners"><span style="will-change:opacity">Partners</span></a><a class="nav-link z-50 relative text-indigo" href="/pricing"><span style="will-change:opacity">Pricing</span></a><div class="pointer-events-none absolute inset-0 h-screen min-w-full backdrop-blur-xl" style="opacity:0;will-change:opacity"></div><div class="absolute inset-x-0 top-0 z-30 min-w-full origin-top overflow-hidden rounded-[3px] bg-white pt-[89px]" style="pointer-events:none;opacity:0;will-change:opacity"><div class="min-h-[250px]"></div></div></nav></div><div class="flex gap-2"><div class="flex items-center gap-x-6"><a class="nav-button text-[15px] font-medium leading-[1.1] tracking-[-0.15px] transition-colors text-indigo hover:text-ocean" href="/search"><svg class="w-[14px]" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 14"><path d="M6.125 10.5a4.375 4.375 0 1 0 0-8.75 4.375 4.375 0 0 0 0 8.75ZM9.219 9.219l3.031 3.031" stroke="currentColor"></path></svg></a><a class="nav-button text-[15px] font-medium leading-[1.1] tracking-[-0.15px] transition-colors max-xl:hidden text-indigo hover:text-ocean" target="_blank" href="https://startree.cloud/login">Login</a><a class="gradient-border-mask nav-button text-indigo" href="/saas-signup">Start for free</a><a class="nav-button text-[15px] font-medium leading-[1.1] tracking-[-0.15px] transition-colors max-xl:hidden text-indigo hover:text-ocean" href="/demo">Book a demo</a></div><div class="-mr-[15px] lg:hidden" role="button" tabindex="0"><div class="hamburger-react" aria-label="Show menu" aria-expanded="false" role="button" style="cursor:pointer;height:48px;position:relative;transition:0.4s cubic-bezier(0, 0, 0, 1);user-select:none;width:48px;outline:none" tabindex="0"><div style="background:#001e43;height:2px;left:15px;position:absolute;width:18px;top:17px;transition:0.4s cubic-bezier(0, 0, 0, 1);transform:none"></div><div style="background:#001e43;height:2px;left:15px;position:absolute;width:18px;top:23px;transition:0.2s cubic-bezier(0, 0, 0, 1);transform:none"></div><div style="background:#001e43;height:2px;left:15px;position:absolute;width:18px;top:29px;transition:0.4s cubic-bezier(0, 0, 0, 1);transform:none"></div></div></div></div></div></div></header><main class=""><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-sky pb-12 lg:pb-[120px]"><div class="pt-[60px] lg:pt-[89px] container"><div><div aria-hidden="true" class="pointer-events-none absolute rounded-full top-[-1430px] left-[-1100px] size-[2000px] md:size-[2117px]" style="background:radial-gradient(47.38% 47.38% at 50% 42.81%, #F94F8D 0%, rgba(233,244,252,0.02) 75.48%, rgba(233,248,255,0.00) 92.49%)"></div><div aria-hidden="true" class="pointer-events-none absolute rounded-full bottom-[-2000px] right-[-3120px] size-[3750px] lg:size-[4309px]" style="background:radial-gradient(47.38% 47.38% at 50% 42.81%, #21C6DC 8.43%, rgba(233, 248, 255, 0.00) 92.49%)"></div><div class="relative isolate overflow-hidden"><div class="container pt-6 md:pt-[72px]"><div class=""><div class="flex w-full flex-col text-center md:text-center"><h6 class="text-label-l mb-2.5 w-full text-ocean md:mb-4">Indexing</h6><h1 class="w-full text-h1 md:w-full md:mx-auto text-indigo mb-3 md:mb-6">Create flexible indexes</h1><div class="prose w-full max-md:text-balance text-18 md:max-w-lg md:mx-auto text-ocean"><p>Harness multiple indexing options to analyze your data any way you want. StarTree supports a wide range of index types that you can apply to any column, letting you analyze your data flexibly and easily.</p> </div><div class="flex w-auto items-center gap-[18px] md:gap-6 mt-[22px] justify-center md:justify-center md:mt-11"><a target="" class="hero-button w-auto " href="/demo"><div class="text-center rounded-full focus-visible:outline focus-visible:outline-2 focus-visible:outline-offset-2 focus-visible:outline-white px-[25px] relative overflow-hidden group isolate overflow-hidden w-auto py-3 md:px-8 md:py-4 text-link-m bg-turmeric text-indigo" type="button" text="[object Object]"><div>Book a demo</div><div class="absolute -z-10 size-[98px] bg-[radial-gradient(50%_50%_at_50%_50%,_#FFFFFF_0%,_rgba(233,248,255,0.00)_100%)] opacity-0 transition-[opacity,transform] group-hover:opacity-100" style="left:0px;top:0px"><div class="absolute inset-0 m-auto size-14 bg-[radial-gradient(50%_50%_at_50%_50%,_#A6E8F1_0%,_rgba(233,248,255,0.00)_100%)]"></div></div></div></a><a target="" class="hero-button w-auto " href="/saas-signup"><div class="text-link-m group flex items-center gap-2 w-auto text-indigo">Start for free<span aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="w-2.5 translate-x-0 transition-transform ease-[0.76,0,0.24,1] group-hover:translate-x-1.5 text-indigo" viewBox="0 0 12 12"><path d="M1 6h10.125M6.625 1.5l4.5 4.5-4.5 4.5" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path></svg></span></div></a></div></div></div><div class="relative w-full max-sm:mx-auto mt-14"><img alt="Indexing Hero V2" loading="lazy" width="1879" height="371" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 max-lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-hero-v2.svg&w=1920&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-hero-v2.svg&w=3840&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-hero-v2.svg&w=3840&q=75"/></div></div></div></div></div></section><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-indigo-900 pt-12 lg:pt-[120px] pb-12 lg:pb-[120px]"><div class="space-y-[50px] md:space-y-20 lg:space-y-24 container"><div class=""><div class="flex w-full flex-col text-center md:text-left"><h2 class="w-full text-h3 md:w-full text-sky">Increase query throughput and improve compute efficiency</h2></div></div><div><div class="grid gap-5 md:grid-cols-2 lg:grid-cols-3 lg:gap-6"><div class="relative isolate flex min-h-[180px] flex-col items-start justify-between gap-10 overflow-hidden rounded-lg p-5 ring-1 md:min-h-[240px] lg:min-h-[280px] lg:p-6 bg-indigo xl:min-h-[380px] ring-white/[0.03]"><img alt="Updates Inserts" loading="lazy" width="128" height="128" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 h-10 w-auto md:h-12 xl:h-16" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FUpdates-inserts.png&w=128&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FUpdates-inserts.png&w=256&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FUpdates-inserts.png&w=256&q=75"/><div><h3 class="text-22 text-balance !font-semibold !leading-[1.2] text-sky">Support diverse use cases with flexible indexing options</h3></div></div><div class="relative isolate flex min-h-[180px] flex-col items-start justify-between gap-10 overflow-hidden rounded-lg p-5 ring-1 md:min-h-[240px] lg:min-h-[280px] lg:p-6 bg-indigo xl:min-h-[380px] ring-white/[0.03]"><img alt="Freshest Data" loading="lazy" width="128" height="128" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 h-10 w-auto md:h-12 xl:h-16" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Ffreshest-data.png&w=128&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Ffreshest-data.png&w=256&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Ffreshest-data.png&w=256&q=75"/><div><h3 class="text-22 text-balance !font-semibold !leading-[1.2] text-sky">Improve query performance with dynamic tuning</h3></div></div><div class="relative isolate flex min-h-[180px] flex-col items-start justify-between gap-10 overflow-hidden rounded-lg p-5 ring-1 md:min-h-[240px] lg:min-h-[280px] lg:p-6 bg-indigo xl:min-h-[380px] ring-white/[0.03]"><img alt="Bolt Power" loading="lazy" width="129" height="128" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 h-10 w-auto md:h-12 xl:h-16" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FBolt-power.png&w=256&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FBolt-power.png&w=320&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FBolt-power.png&w=320&q=75"/><div><h3 class="text-22 text-balance !font-semibold !leading-[1.2] text-sky">Immediately index your data</h3></div></div></div></div></div></section><section id="" class="relative isolate overflow-visible bg-white pt-12 lg:pt-[120px] pb-[28px] md:pb-12 lg:pb-20"><div class="space-y-[50px] md:space-y-20 lg:space-y-24 container"><div class=""><div class="flex w-full flex-col text-center md:text-left"><h2 class="w-full text-h2 md:custom text-indigo mb-3 md:mb-6" style="max-width:700px">Optimize query performance and cost with comprehensive indexing options</h2><div class="prose w-full max-md:text-balance text-18 md:custom text-ocean" style="max-width:460px"><p>Unlock timely and accurate insights from your data in motion and power your real-time analytics application.</p> </div></div></div><div class="grid gap-6 lg:grid-cols-4 lg:pt-10"><nav class="max-lg:hidden lg:sticky lg:top-40 lg:space-y-[26px] lg:self-start"><a href="#vector-index" class="text-label-s flex text-left transition-colors text-indigo">Vector Index</a><a href="#star-tree-index" class="text-label-s flex text-left transition-colors text-ocean">Star-Tree Index</a><a href="#json-index" class="text-label-s flex text-left transition-colors text-ocean">JSON Index</a><a href="#text-index" class="text-label-s flex text-left transition-colors text-ocean">Text Index</a></nav><div class="space-y-[27px] lg:col-span-3"><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="vector-index"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">Vector Index</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Quickly and efficiently search lookups on high-dimension vector data with StarTree. Ideal for use cases around GenerativeAI (GenAI), Retrieval Augmented Generation (RAG), chatbots and Natural Language Processing (NLP), and recommendation systems.</p> </div></div></div><img alt="Indexing Vector V3" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-vector-v3.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-vector-v3.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-vector-v3.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] left-[-577px] top-[-660px] bg-[radial-gradient(50%_50%_at_50%_50%,_#37D992_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-730px] right-[-697px] bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(242,251,255,0.00)_100%)]"></div></div><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="star-tree-index"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">Star-Tree Index</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Build an intelligent materialized view for pre-computing certain aggregations for a wide range of dimension filters while improving query latency and query throughput. Star-Tree Index, unique to Apache Pinot, provides an innovative way to control the degree of materialization, thus allowing the user to trade off query latency versus storage overhead.</p> </div></div></div><img alt="Indexing Startree V5" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-startree-v5.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-startree-v5.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-startree-v5.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-645px] left-[-803px] bg-[radial-gradient(50%_50%_at_50%_50%,_#F94F8D_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] right-[-739px] top-[-408px] -rotate-12 bg-[radial-gradient(50%_50%_at_50%_50%,_#07ACC2_0%,_rgba(242,251,255,0.00)_100%)]"></div></div><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="json-index"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">JSON Index</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Handle structured and semi-structured data while enabling extremely fast query processing on highly nested JSON columns. Users can analyze free structured JSON or text documents and ingest nested JSON columns as-is — without needing to preprocess or transform them in any way.</p> </div></div></div><img alt="Indexing Json V3" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-json-v3.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-json-v3.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-json-v3.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-730px] right-[-697px] -rotate-12 bg-[radial-gradient(50%_50%_at_50%_50%,_#6F42C1_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px]"></div></div><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="text-index"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">Text Index</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Perform powerful text search queries on arbitrary text data by configuring a Text Index to accelerate query processing.</p> </div></div></div><img alt="Indexing Text V3" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-text-v3.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-text-v3.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Findexing-text-v3.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-645px] left-[-803px] bg-[radial-gradient(50%_50%_at_50%_50%,_#37D992_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] right-[-739px] top-[-408px] -rotate-12 bg-[radial-gradient(50%_50%_at_50%_50%,_#48809F_0%,_rgba(242,251,255,0.00)_100%)]"></div></div></div></div></div></section><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-white pt-[28px] md:pt-12 lg:pt-20 pb-[28px] md:pb-12 lg:pb-20"><div class="space-y-12 md:space-y-20 lg:space-y-[120px] container"><div class=""><div class="relative isolate overflow-hidden rounded-lg bg-indigo-900 py-14 md:rounded-xl md:py-[104px]"><div class="mx-md:text-balance mx-auto max-w-2xl md:max-w-[721px]" style="opacity:0;will-change:opacity"><div style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)"><img alt="Just Eat Logo White" loading="lazy" width="977" height="234" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 mx-auto h-6" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Fjust_eat_logo-white.svg&w=1080&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Fjust_eat_logo-white.svg&w=2048&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Fjust_eat_logo-white.svg&w=2048&q=75"/></div><figure class="mt-10 md:mt-12"><blockquote class="text-28 text-center text-sky max-lg:px-3" style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)"><div><p>“StarTree ThirdEye really changed the way of working in our data analytics department. We’re able to spot data quality issues way before our stakeholders do and prevent duplicate work. It’s very impactful to have ThirdEye embedded in your organization, because you become a proactive partner to your data consumers.”</p> </div></blockquote><figcaption class="mt-10 flex items-center justify-center gap-x-5 md:mt-12"><div class="size-12 overflow-hidden rounded-full bg-sky-25 md:size-16" style="opacity:0;will-change:opacity"><img alt="JustEatTakeaway Leon Graveland" loading="lazy" width="620" height="620" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2FJustEatTakeaway-Leon-Graveland.png&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2FJustEatTakeaway-Leon-Graveland.png&w=1920&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2FJustEatTakeaway-Leon-Graveland.png&w=1920&q=75"/></div><div><div class="text-h8 text-white" style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)">Leon Graveland</div><div class="text-16 mt-px text-sky-200" style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)">Sr. Data Engineer</div></div></figcaption></figure></div><div aria-hidden="true" class="pointer-events-none absolute bottom-[-900px] left-[-50%] -z-10 size-[1950px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(20,92,132,0.00)_100%)] opacity-70 md:bottom-[-1492px] md:left-[-30%]"></div></div></div></div></section><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-white pt-[28px] md:pt-12 lg:pt-20 pb-[56px] md:pb-24 lg:pb-[160px]"><div class="space-y-12 md:space-y-20 lg:space-y-[120px] container"><div class=""><div class="flex w-full flex-col text-center md:text-left"><h6 class="text-label-l mb-2.5 w-full text-ocean md:mb-4">keep exploring</h6><h2 class="w-full text-h2 md:max-w-2xl text-indigo">The most powerful real-time analytics platform</h2></div></div><div class="grid gap-5 md:grid-cols-2 lg:grid-cols-12 lg:gap-6"><a class="aspect-[2/1]_ group relative isolate flex flex-col overflow-hidden rounded-lg bg-sky p-5 md:justify-between lg:rounded-xl lg:p-8 lg:even:flex-col-reverse lg:aspect-[690/490]_ lg:col-span-7 group" href="/products/tiered-storage"><svg class="absolute right-8 top-8 w-[14px] opacity-0 transition-opacity group-hover:opacity-100" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 13"><path stroke="#00152E" stroke-linecap="round" stroke-width="1.32" d="M1 6.4h12.15"></path><path stroke="#00152E" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.32" d="m7.75 1 5.4 5.4-5.4 5.4"></path></svg><div><h3 class="text-h4 text-balancex text-indigo">Simplified tiered storage</h3><div class="text-18 mt-2.5 text-ocean max-lg:text-balance md:mt-4 lg:max-w-[540px]">Analyze all your data, new and historical, without slowing down queries or blowing your budget. StarTree automatically stores the data you access most often for super-fast results.</div></div><img alt="Tiered Storage Vertical V2" loading="lazy" width="626" height="358" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Ftiered_storage-vertical-v2.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Ftiered_storage-vertical-v2.svg&w=1920&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Ftiered_storage-vertical-v2.svg&w=1920&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 rounded-full left-[-889px] top-[-1400px] aspect-1 size-[1778px] bg-[radial-gradient(50%_50%_at_50%_50%,_#37D992_0%,_rgba(233,248,255,0.00)_100%)]"></div><div aria-hidden="true" class="pointer-events-none -z-10 scale-90 absolute bottom-[-1400px] right-[-1006px] aspect-1 size-[1778px] bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(233,248,255,0.00)_100%)]"></div></a><a class="aspect-[2/1]_ group relative isolate flex flex-col overflow-hidden rounded-lg bg-sky p-5 md:justify-between lg:rounded-xl lg:p-8 lg:even:flex-col-reverse lg:aspect-[486/490]_ lg:col-span-5 group" href="/products/real-time-upserts"><svg class="absolute right-8 top-8 w-[14px] opacity-0 transition-opacity group-hover:opacity-100" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 13"><path stroke="#00152E" stroke-linecap="round" stroke-width="1.32" d="M1 6.4h12.15"></path><path stroke="#00152E" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.32" d="m7.75 1 5.4 5.4-5.4 5.4"></path></svg><div><h3 class="text-h4 text-balancex text-indigo">Scalable real-time upserts</h3><div class="text-18 mt-2.5 text-ocean max-lg:text-balance md:mt-4">Upserts are two operations in one. If a data record doesn’t exist, it performs an insert. If it does already exist, it performs an update. StarTree can perform upserts scalably at millons of rows per second.</div></div><img alt="Scalable Real Time Upserts" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FScalable-real-time-upserts.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FScalable-real-time-upserts.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FScalable-real-time-upserts.svg&w=1080&q=75"/></a><a class="aspect-[2/1]_ group relative isolate flex flex-col overflow-hidden rounded-lg bg-sky p-5 md:justify-between lg:rounded-xl lg:p-8 lg:even:flex-col-reverse lg:aspect-[588/490]_ lg:col-span-6 group" href="/products/multi-stage-query-engine"><svg class="absolute right-8 top-8 w-[14px] opacity-0 transition-opacity group-hover:opacity-100" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 13"><path stroke="#00152E" stroke-linecap="round" stroke-width="1.32" d="M1 6.4h12.15"></path><path stroke="#00152E" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.32" d="m7.75 1 5.4 5.4-5.4 5.4"></path></svg><div><h3 class="text-h4 text-balancex text-indigo">Multi-stage query engine</h3><div class="text-18 mt-2.5 text-ocean max-lg:text-balance md:mt-4 lg:max-w-[500px]">Trust StarTree to handle your multi-stage data processing. Run complex SQL queries without sacrificing blazing fast query performance. And gain the business insights your teams need, in real-time.</div></div><img alt="Real Time Upserts" loading="lazy" width="588" height="580" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Freal-time-upserts.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Freal-time-upserts.svg&w=1200&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Freal-time-upserts.svg&w=1200&q=75"/></a><a class="aspect-[2/1]_ group relative isolate flex flex-col overflow-hidden rounded-lg bg-sky p-5 md:justify-between lg:rounded-xl lg:p-8 lg:even:flex-col-reverse lg:aspect-[588/490]_ lg:col-span-6 group" href="/products/autoscaling-minions"><svg class="absolute right-8 top-8 w-[14px] opacity-0 transition-opacity group-hover:opacity-100" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 13"><path stroke="#00152E" stroke-linecap="round" stroke-width="1.32" d="M1 6.4h12.15"></path><path stroke="#00152E" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.32" d="m7.75 1 5.4 5.4-5.4 5.4"></path></svg><div><h3 class="text-h4 text-balancex text-indigo">Autoscaling minions</h3><div class="text-18 mt-2.5 text-ocean max-lg:text-balance md:mt-4 lg:max-w-[500px]">Save costs on your cloud infrastructure with autoscaling minions. Ensure tasks are processed efficiently and drop the legwork of repartitioning data post-ingestion and merging smaller segments into larger ones.</div></div><img alt="Auto Scaling Minions 2" loading="lazy" width="1176" height="902" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FAuto-scaling-minions-2.png&w=1200&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FAuto-scaling-minions-2.png&w=3840&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FAuto-scaling-minions-2.png&w=3840&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 rounded-full right-[-813px] top-[-1300px] size-[1778px] bg-[radial-gradient(50%_50%_at_50%_50%,_#AE95DC_0%,_rgba(233,248,255,0.00)_100%)]"></div><div aria-hidden="true" class="pointer-events-none -z-10 scale-90"></div></a></div></div></section></main><div class="space-y-4 bg-indigo py-4 md:pb-[60px] md:pt-16"><div class="header-container"><div class="relative isolate overflow-hidden rounded-lg bg-white/[0.03] px-6 py-10 md:rounded-xl md:px-8 md:py-16 lg:px-20 lg:py-[125px]"><h2 class="text-cta relative z-10 max-w-xl text-sky-25">Ready to deploy real-time analytics?</h2><div class="text-18 prose prose-sky relative z-10 mt-3 !max-w-xl !text-sky-200 md:mt-6"><p>Start for free or book a demo with our team.</p> </div><div class="relative z-10 mt-[22px] flex items-center gap-x-[18px] sm:gap-x-6 md:mt-[47px]"><a class="cta-button block" href="/saas-signup"><div class="text-center rounded-full focus-visible:outline focus-visible:outline-2 focus-visible:outline-offset-2 focus-visible:outline-white px-[25px] relative overflow-hidden group isolate overflow-hidden py-3 md:px-8 md:py-4 text-link-m bg-turmeric text-indigo"><div>Start for free</div><div class="absolute -z-10 size-[98px] bg-[radial-gradient(50%_50%_at_50%_50%,_#FFFFFF_0%,_rgba(233,248,255,0.00)_100%)] opacity-0 transition-[opacity,transform] group-hover:opacity-100" style="left:0px;top:0px"><div class="absolute inset-0 m-auto size-14 bg-[radial-gradient(50%_50%_at_50%_50%,_#A6E8F1_0%,_rgba(233,248,255,0.00)_100%)]"></div></div></div></a><a class="cta-button block" href="/demo"><div class="text-link-m group flex items-center gap-2 text-white">Book a demo<span aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="w-2.5 translate-x-0 transition-transform ease-[0.76,0,0.24,1] group-hover:translate-x-1.5 text-white" viewBox="0 0 12 12"><path d="M1 6h10.125M6.625 1.5l4.5 4.5-4.5 4.5" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path></svg></span></div></a></div><div class="pointer-events-none absolute left-[-90%] top-[-40%] aspect-[2311/1052] w-[910px] bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(77,_209,_227,_0.00)_100%)] blur-lg [clip-path:_ellipse(1155px_526px_at_50%_50%)] sm:w-[150%] xl:top-[-110%] xl:w-[2311px] transition-transform duration-[3000ms] rotate-[0deg] scale-100 rotate-[0deg] scale-100"></div><div class="pointer-events-none absolute bottom-[-50%] right-[-90%] aspect-[2311/1052] w-[910px] bg-[radial-gradient(50%_50%_at_50%_50%,_#6F42C1_0%,_rgba(111,_66,_193,_0.00)_100%)] blur-lg [clip-path:_ellipse(1155px_526px_at_50%_50%)] md:w-[130%] xl:bottom-[-140%] xl:w-[2311px] transition-transform duration-[3000ms] rotate-[0deg] scale-100 rotate-[0deg] scale-100"></div></div></div></div><footer class="pb-8 pt-10 md:pb-10 md:pt-[60px] bg-indigo" aria-labelledby="footer-heading"><h2 id="footer-heading" class="sr-only">Footer</h2><div class="container"><div class="be-ix-link-block"></div><div class="grid grid-cols-2 gap-x-6 gap-y-10 sm:grid-cols-3 md:gap-9 lg:flex lg:justify-between lg:gap-[9px]"><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Platform</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/startree-cloud">Platform Overview</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/startree-thirdeye">Anomaly Detection</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/real-time-upserts">Real-Time Upserts</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/tiered-storage">Tiered Storage</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/indexing">Indexing</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/multi-stage-query-engine">Multi-Stage Query Engine</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/autoscaling-minions">Autoscaling Minions</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/data-manager">Integrations</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/security-compliance">Security & Compliance</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/deployment-options">Deployment Options</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/partners">Partner</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/pricing">Pricing</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Industries</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/financial-services">Financial Services</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/retail">Retail</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/gaming">Gaming</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/delivery-and-ridesharing">Delivery & Ridesharing</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/human-resources">Human Resources</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/healthcare">Healthcare</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Use cases</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/fraud-detection">Fraud Detection</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/personalization">Personalization</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/business-metrics-monitoring">Business Metrics Monitoring</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">For Developers</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="_blank" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="https://dev.startree.ai/docs/">Docs</a></li><li><a target="_blank" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="https://support.startree.ai/">Support</a></li><li><a target="_blank" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="https://dev.startree.ai/docs/community/">Community</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Resources</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/user-stories">User Stories</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/resources/category/blog">Blog</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/resources/category/videos">Videos</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/glossary">Glossary</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/resources/category/events-webinars">Events & Webinars</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/resources/category/fundamentals">Fundamentals</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/rta-summit">RTA Summit</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/all-stars">StarTree All-Stars</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Company</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/about">About</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/careers">Careers</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/news">Press</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/contact-us">Contact</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/legal">Legal</a></li><li></li></ul></div></div><div class="mt-10 flex gap-x-6 gap-y-6 max-sm:flex-col-reverse lg:mt-[140px] lg:gap-x-[167px]"><img alt="Svg 223107605 1699873195" loading="lazy" width="80" height="80" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 max-sm:max-w-14" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F06%2Fsvg-223107605-1699873195.svg&w=96&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F06%2Fsvg-223107605-1699873195.svg&w=256&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F06%2Fsvg-223107605-1699873195.svg&w=256&q=75"/><div class="w-full max-w-[459px] shrink-0"><h3 class="text-22-t mb-5 !font-normal !leading-[1.2] !tracking-[-0.22px] text-sky md:mb-7">Get the latest updates</h3><form class="flex w-full items-center gap-x-4 rounded-full border border-white/10 bg-white/[0.03] px-5 py-3.5 md:px-6 md:py-3.5"><input type="email" name="email" required="" class="flex-1 border-0 bg-transparent p-0 text-[15px] leading-[1.1] tracking-[-0.3px] text-sky outline-0 ring-0 placeholder:text-white/50 focus:ring-0" placeholder="Your email address"/><button type="submit" class="w-2.5 shrink-0"><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="text-white" viewBox="0 0 12 12"><path stroke="currentColor" stroke-linecap="round" stroke-width="1.1" d="M1 6h10.125"></path><path stroke="currentColor" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.1" d="m6.625 1.5 4.5 4.5-4.5 4.5"></path></svg><span class="sr-only">Subscribe</span></button></form></div></div><div class="mt-10 flex gap-y-6 max-md:flex-col md:items-end md:justify-between lg:mt-[160px] xl:items-center"><div class="flex flex-1 gap-x-10 gap-y-6 max-lg:flex-col lg:items-center xl:gap-x-[126px]"><p class="text-link-s text-sky/40">© 2025 StarTree Inc. All rights reserved.</p><div class="flex flex-wrap gap-x-6 gap-y-2"><a class="text-link-s block text-sky-25/60 transition-colors duration-300 hover:text-sky" href="/startree-trademark-policy">Trademark Policy</a><a class="text-link-s block text-sky-25/60 transition-colors duration-300 hover:text-sky" href="/privacy-policy">Privacy Policy</a><a class="text-link-s block text-sky-25/60 transition-colors duration-300 hover:text-sky" href="/terms-conditions">Terms of Use</a><a class="text-link-s block text-sky-25/60 transition-colors duration-300 hover:text-sky" href="/responsible-disclosure">Responsible Disclosure</a></div></div><div class="flex space-x-4 max-md:order-first"><a target="_blank" href="https://www.linkedin.com/company/startreedata/"><span class="block transition-colors duration-300 text-sky hover:text-sky/80"><span class="sr-only">linkedin</span><div class="w-5" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 20 20"><path fill="currentColor" fill-rule="evenodd" d="M2.285 17.45h3.171V6.9h-3.17v10.55ZM17.081 11.577v5.874h-3.104v-5.548c0-1.414-.5-2.284-1.602-2.284-.713-.008-1.354.47-1.602 1.196a2.28 2.28 0 0 0-.1.87v5.766H7.567V7.226h3.104V8.64c.583-1.081 1.652-1.744 2.804-1.74 2.003 0 3.605 1.522 3.605 4.677ZM3.915 2.685c-.814-.09-1.54.556-1.623 1.44-.004.045-.006.09-.007.135.001.873.653 1.579 1.456 1.577.028 0 .056 0 .084-.002.814.088 1.54-.555 1.623-1.44.003-.046.006-.09.007-.135.029-.843-.576-1.55-1.35-1.582-.064-.002-.127 0-.19.007Z" clip-rule="evenodd"></path></svg></div></span></a><a target="_blank" href="https://www.youtube.com/startreedata"><span class="block transition-colors duration-300 text-sky hover:text-sky/80"><span class="sr-only">youtube</span><div class="w-5" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 20 20"><path fill="currentColor" d="M15.057 3H4.685C2.65 3 1 4.75 1 6.908v5.5c0 2.158 1.65 3.908 3.685 3.908h10.372c2.035 0 3.685-1.75 3.685-3.909V6.908C18.742 4.75 17.092 3 15.057 3Zm-2.492 6.925L7.714 12.38c-.13.066-.279-.034-.279-.186V7.131c0-.154.153-.254.283-.184l4.851 2.608c.145.077.142.297-.004.37Z"></path></svg></div></span></a><a target="_blank" href="https://twitter.com/startreedata"><span class="block transition-colors duration-300 text-sky hover:text-sky/80"><span class="sr-only">x</span><div class="w-5" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 20 20"><path fill="currentColor" d="m10.956 8.85 5.424-6.173h-1.285l-4.711 5.36-3.76-5.36H2.284l5.688 8.106-5.688 6.473H3.57l4.972-5.661 3.972 5.661h4.338M4.034 3.626h1.974l9.086 12.728H13.12"></path></svg></div></span></a></div></div></div></footer></div><script id="__NEXT_DATA__" type="application/json">{"props":{"pageProps":{"page":{"ID":3137,"post_author":"4","post_date":"2024-08-29 17:31:46","post_date_gmt":"2024-08-29 17:31:46","post_title":"Indexing","post_status":"publish","comment_status":"closed","ping_status":"closed","post_name":"indexing","post_modified":"2024-11-09 20:26:26","post_modified_gmt":"2024-11-09 20:26:26","post_parent":267,"guid":"https://startree.ai/?page_id=3137","menu_order":3,"post_type":"page","filter":"raw","url":"https://startree.ai/products/indexing","page_options":{"header_color":"white","is_first_component_overflowing_nav":true,"footer_color":"indigo","banner":{"background_color":"indigo"},"popup":{"variants":"blue"}},"sections":[{"acf_fc_layout":"section","components":[{"acf_fc_layout":"mastheads","mastheads":[{"acf_fc_layout":"page_masthead","layout":"one_col","gradient":"red_blue","text_card":{"subheading":"Indexing","heading":"Create flexible indexes","content":"\u003cp\u003eHarness multiple indexing options to analyze your data any way you want. StarTree supports a wide range of index types that you can apply to any column, letting you analyze your data flexibly and easily.\u003c/p\u003e\n","links":[{"link":{"link":{"title":"Book a demo","url":"/demo/"},"type":"button","button":{"type":"default","background_color":"tumeric","size":"default","custom_classes":"hero-button"},"text":{"color":"indigo"}}},{"link":{"link":{"title":"Start for free","url":"/saas-signup/"},"type":"text","button":{"type":"default","size":"default"},"text":{"color":"indigo","custom_classes":"hero-button"}}}],"options":{"text_alignment":"center","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h1","heading_font_size":"default","heading_font_color":"indigo","heading_max_width":"w-full","content_font_size":"18","content_font_color":"ocean","content_max_width":"max-w-lg","custom_y_spacing":"default"},"page_callout":{"layout":"row"}},"add_asset":true,"asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/indexing-hero-v2.svg","alt":"Indexing Hero V2","width":1879,"height":371}}},"asset_spacing":"default"}]}],"padding_top":"none","padding_bottom":"120","inner_spacing":"none","has_container":true,"background":{"background_color":"sky"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"text_card","text_card":{"heading":"Increase query throughput and improve compute efficiency","options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"h3","heading_font_color":"sky","heading_max_width":"w-full","content_font_size":"18","content_font_color":"ocean","content_max_width":"w-full","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}},{"acf_fc_layout":"grids","grids":[{"acf_fc_layout":"icon_hover_cards","layout":"default","card_bg_color":"indigo","cards":[{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Updates-inserts.png","alt":"Updates Inserts","width":128,"height":128},"heading":"Support diverse use cases with flexible indexing options","content":"\u003cp class=\"p1\"\u003eChoose the right indexing strategy for your use case, whether you\u0026#8217;re performing root cause analysis or running ad hoc analytics. StarTree offers best-in-class performance at any scale with indexing support for: Vector Index, Inverted Index, Sorted Index, Range Index, JSON Index, Text Index, Geo Index, Star-Tree Index, Bloom Filter, Timestamp Index, and Sparse Index.\u003c/p\u003e\n","theme":"yellow"},{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/freshest-data.png","alt":"Freshest Data","width":128,"height":128},"heading":"Improve query performance with dynamic tuning","content":"\u003cp class=\"p1\"\u003eAutomatically identify the right index for frequently run queries, and leverage real-time insights to identify queries with poor performance, Dynamically add indexes to specific columns and add derived columns for performance improvements.\u003c/p\u003e\n","theme":"blue"},{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Bolt-power.png","alt":"Bolt Power","width":129,"height":128},"heading":"Immediately index your data","content":"\u003cp\u003eMany databases have a lag between data ingestion and indexing, delaying when you can run queries against that data. In StarTree, data ingestion and indexing happen simultaneously. You\u0026#8217;ll be able to immediately find the freshest data in your query results.\u003c/p\u003e\n","theme":"purple"}],"resource_callout":[{"ID":499,"post_title":"TEST — What is Apache Pinot?","categories":[{"id":4,"name":"eBooks \u0026amp; Whitepapers","slug":"ebooks-whitepapers"}],"acf":{"preview":{"thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/A4-1.svg","alt":"A4 1","width":245,"height":258},"intro":"Apache Pinot is an open source distributed database designed for real-time, user-facing analytics.","show_video_icon":true,"resource_callout_thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/image-31.jpg","alt":"Image 31","width":518,"height":292},"theme":"grey_green"},"layout":"papers"}}],"text_card":{"options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"default","heading_font_color":"indigo","heading_max_width":"w-full","content_font_size":"18","content_font_color":"ocean","content_max_width":"w-full","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}}]}],"padding_top":"120","padding_bottom":"120","inner_spacing":"96","has_container":true,"background":{"background_color":"indigo-900"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"text_card","text_card":{"heading":"Optimize query performance and cost with comprehensive indexing options","content":"\u003cp\u003eUnlock timely and accurate insights from your data in motion and power your real-time analytics application.\u003c/p\u003e\n","options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"h2","heading_font_color":"indigo","heading_max_width":"custom","custom_heading_max_width":"700","content_font_size":"18","content_font_color":"ocean","content_max_width":"custom","custom_content_max_width":"460","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}},{"acf_fc_layout":"content","content":[{"acf_fc_layout":"sticky_nav_and_card_scroll","cards":[{"label":"Vector Index","heading":"Vector Index","content":"\u003cp\u003eQuickly and efficiently search lookups on high-dimension vector data with StarTree. Ideal for use cases around GenerativeAI (GenAI), Retrieval Augmented Generation (RAG), chatbots and Natural Language Processing (NLP), and recommendation systems.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/indexing-vector-v3.svg","alt":"Indexing Vector V3","width":464,"height":460}}},"theme":"green_blue"},{"label":"Star-Tree Index","heading":"Star-Tree Index","content":"\u003cp\u003eBuild an intelligent materialized view for pre-computing certain aggregations for a wide range of dimension filters while improving query latency and query throughput. Star-Tree Index, unique to Apache Pinot, provides an innovative way to control the degree of materialization, thus allowing the user to trade off query latency versus storage overhead.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/indexing-startree-v5.svg","alt":"Indexing Startree V5","width":464,"height":460}}},"theme":"red_blue"},{"label":"JSON Index","heading":"JSON Index","content":"\u003cp\u003eHandle structured and semi-structured data while enabling extremely fast query processing on highly nested JSON columns. Users can analyze free structured JSON or text documents and ingest nested JSON columns as-is — without needing to preprocess or transform them in any way.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/indexing-json-v3.svg","alt":"Indexing Json V3","width":464,"height":460}}},"theme":"purple"},{"label":"Text Index","heading":"Text Index","content":"\u003cp\u003ePerform powerful text search queries on arbitrary text data by configuring a Text Index to accelerate query processing.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/indexing-text-v3.svg","alt":"Indexing Text V3","width":464,"height":460}}},"theme":"green_grey"}]}]}],"padding_top":"120","padding_bottom":"80","inner_spacing":"96","has_container":true,"overflow":true,"background":{"background_color":"white"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"content","content":[{"acf_fc_layout":"testimonial_slider","testimonials":[{"ID":4690,"post_title":"Just Eat Takeaway - Leon Graveland","acf":{"quote":"\u003cp\u003e\u0026#8220;StarTree ThirdEye really changed the way of working in our data analytics department. We\u0026#8217;re able to spot data quality issues way before our stakeholders do and prevent duplicate work. It\u0026#8217;s very impactful to have ThirdEye embedded in your organization, because you become a proactive partner to your data consumers.\u0026#8221;\u003c/p\u003e\n","job_role":"Sr. Data Engineer","logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/24px-just_eat_logo-dark.svg","alt":"24px Just Eat Logo Dark","width":101,"height":24},"inverted_logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/just_eat_logo-white.svg","alt":"Just Eat Logo White","width":977,"height":234},"avatar":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/JustEatTakeaway-Leon-Graveland.png","alt":"JustEatTakeaway Leon Graveland","width":620,"height":620},"name":"Leon Graveland"}}],"is_dark":true}]}],"padding_top":"80","padding_bottom":"80","inner_spacing":"120","has_container":true,"background":{"background_color":"white"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"text_card","text_card":{"subheading":"keep exploring","heading":"The most powerful real-time analytics platform","options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"h2","heading_font_color":"indigo","heading_max_width":"max-w-2xl","content_font_size":"18","content_font_color":"ocean","content_max_width":"w-full","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}},{"acf_fc_layout":"grids","grids":[{"acf_fc_layout":"use_case_grid","cards":[{"link":{"title":"Tiered Storage","url":"/products/tiered-storage"},"heading":"Simplified tiered storage","content":"Analyze all your data, new and historical, without slowing down queries or blowing your budget. StarTree automatically stores the data you access most often for super-fast results.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/tiered_storage-vertical-v2.svg","alt":"Tiered Storage Vertical V2","width":626,"height":358},"theme":"ocean_river","width":"7"},{"link":{"title":"Real-Time Upserts","url":"/products/real-time-upserts"},"heading":"Scalable real-time upserts","content":"Upserts are two operations in one. If a data record doesn’t exist, it performs an insert. If it does already exist, it performs an update. StarTree can perform upserts scalably at millons of rows per second.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Scalable-real-time-upserts.svg","alt":"Scalable Real Time Upserts","width":464,"height":460},"width":"5"},{"link":{"title":"Multi-Stage Query Engine","url":"/products/multi-stage-query-engine"},"heading":"Multi-stage query engine","content":"Trust StarTree to handle your multi-stage data processing. Run complex SQL queries without sacrificing blazing fast query performance. And gain the business insights your teams need, in real-time.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/real-time-upserts.svg","alt":"Real Time Upserts","width":588,"height":580},"width":"6"},{"link":{"title":"Autoscaling Minions","url":"/products/autoscaling-minions"},"heading":"Autoscaling minions","content":"Save costs on your cloud infrastructure with autoscaling minions. Ensure tasks are processed efficiently and drop the legwork of repartitioning data post-ingestion and merging smaller segments into larger ones.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Auto-scaling-minions-2.png","alt":"Auto Scaling Minions 2","width":1176,"height":902},"theme":"jade","width":"6"}]}]}],"padding_top":"80","padding_bottom":"160","inner_spacing":"120","has_container":true,"background":{"background_color":"white"}}],"seo":{"title":"Flexible Indexing with StarTree Cloud | StarTree","description":"Optimize query performance and cost with comprehensive flexible indexing options from StarTree Cloud. Learn more."},"featured_image":{"width":1120,"height":600}},"postListing":{},"options":{"menu":{"header_links":[{"link":{"title":"Platform","url":"/products/startree-cloud","target":""},"has_submenu":true,"submenu":{"submenu_type":"platform","platform":{"nav":[{"heading":"","links":[{"link":{"title":"Anomaly Detection","url":"/products/startree-thirdeye","target":""},"description":"Explore StarTree ThirdEye.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Anomaly-Detection.svg","alt":"Anomaly Detection","width":44,"height":44},"layout":""}]},{"heading":"Features","links":[{"link":{"title":"Real-Time Upserts","url":"/products/real-time-upserts","target":""},"description":"Perform inserts \u0026 updates.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Real-Time-Updates.svg","alt":"Real Time Updates","width":44,"height":44},"layout":""},{"link":{"title":"Tiered Storage","url":"/products/tiered-storage","target":""},"description":"Analyze all your data.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Tiered-Storage.svg","alt":"Tiered Storage","width":44,"height":44},"layout":""},{"link":{"title":"Indexing","url":"/products/indexing","target":""},"description":"Create flexible indexes.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Indexing.svg","alt":"Indexing","width":44,"height":44},"layout":""},{"link":{"title":"Multi-Stage Query Engine","url":"/products/multi-stage-query-engine","target":""},"description":"Run complex SQL queries.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Multi-stage-query-engine.svg","alt":"Multi Stage Query Engine","width":44,"height":44},"layout":""},{"link":{"title":"Autoscaling Minions","url":"/products/autoscaling-minions","target":""},"description":"Save costs on your infra.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Auto-scaling-minions.svg","alt":"Auto Scaling Minions","width":44,"height":44},"layout":""},{"link":{"title":"Fast \u0026 Scalable Data Ingestion","url":"/products/data-manager","target":""},"description":"Explore StarTree Data Manager.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/data_manger_icon-bkg.svg","alt":"Data Manger Icon Bkg","width":44,"height":44},"layout":""}]},{"heading":"Technology","links":[{"link":{"title":"Security \u0026 Compliance","url":"/security-compliance","target":""},"description":"Enterprise-grade security.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Security.svg","alt":"Security","width":44,"height":44},"layout":""},{"link":{"title":"Deployment Options","url":"/deployment-options","target":""},"description":"BYoC or use our SaaS.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Deployment-options.svg","alt":"Deployment Options Icon","width":44,"height":44},"layout":""},{"link":{"title":"Technology Partners","url":"/partners","target":""},"description":"AWS, Google Cloud \u0026 Azure.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Partners.svg","alt":"Partners","width":44,"height":44},"layout":""}]}],"featured_link":{"link":{"title":"Platform Overview","url":"/products/startree-cloud","target":""},"description":"Meet StarTree Cloud, the fully-managed DBaaS.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Frame-1948759746-1.svg","alt":"Frame 1948759746","width":304,"height":281},"layout":"platform"}},"solutions":{"nav":false},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}},{"link":{"title":"Solutions","url":"/#","target":""},"has_submenu":true,"submenu":{"submenu_type":"solutions","platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":[{"heading":"By Industry","links":[{"link":{"title":"Financial Services","url":"/solutions/financial-services","target":""},"description":"Build personal finance products.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Fintech.svg","alt":"Fintech","width":44,"height":44},"layout":""},{"link":{"title":"Transportation, Delivery, \u0026 Rideshare","url":"/solutions/delivery-and-ridesharing","target":""},"description":"Power your location-based services.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/devliery-rideshare_icon-bkg.svg","alt":"Devliery Rideshare Icon Bkg","width":44,"height":44},"layout":""},{"link":{"title":"Retail","url":"/solutions/retail","target":""},"description":"Understand shopping habits.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Shopping.svg","alt":"Shopping","width":44,"height":44},"layout":""},{"link":{"title":"Human Resources","url":"/solutions/hr","target":""},"description":"Enhance employee experiences.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/hr_icon-bkg.svg","alt":"Hr Icon Bkg","width":44,"height":44},"layout":""},{"link":{"title":"Gaming","url":"/solutions/gaming","target":""},"description":"Deliver hyper-personalized gaming analytics.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/gaming_icon-bkg.svg","alt":"Gaming Icon Bkg","width":44,"height":44},"layout":""},{"link":{"title":"Healthcare","url":"/solutions/healthcare","target":""},"description":"Provide personalized patient care.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/healthcare_icon-bkg.svg","alt":"Healthcare Icon Bkg","width":44,"height":44},"layout":""}]},{"heading":"By use case","links":[{"link":{"title":"Observability","url":"/solutions/observability","target":""},"description":"Real-time insights for critical business data.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2025/02/observability_icon-bkg_fill.svg","alt":"Observability Icon Bkg Fill","width":45,"height":44},"layout":""},{"link":{"title":"Fraud Detection","url":"/solutions/fraud-detection","target":""},"description":"Detect fraud in real-time.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Fraud-detection.svg","alt":"Fraud Detection","width":44,"height":44},"layout":""},{"link":{"title":"Business Metrics Monitoring","url":"/solutions/business-metrics-monitoring","target":""},"description":"Track key performance indicators.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Analytics.svg","alt":"Analytics","width":44,"height":44},"layout":""},{"link":{"title":"Personalization","url":"/solutions/personalization","target":""},"description":"Tailor products with real-time data.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Personalisation.svg","alt":"Personalisation","width":44,"height":44},"layout":""}]}]},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}},{"link":{"title":"For Developers","url":"https://dev.startree.ai/","target":""},"has_submenu":true,"submenu":{"submenu_type":"developers","platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":false},"developers":{"featured_link":{"link":{"title":"Docs","url":"https://dev.startree.ai/docs","target":"_blank"},"description":"Start building your real-time analytics application.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Group-64280.svg","alt":"Group 64280","width":199,"height":280},"layout":"devs"},"links":[{"link":{"title":"Support","url":"https://support.startree.ai/","target":"_blank"},"description":"Get first-rate support from dedicated engineers.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/06/Frame-1948759621.jpg","alt":"Frame 1948759621","width":844,"height":492},"layout":""},{"link":{"title":"Community","url":"https://dev.startree.ai/docs/community/","target":"_blank"},"description":"Join our real-time community.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/06/Frame-1948759621-1.jpg","alt":"Frame 1948759621 1","width":844,"height":492},"layout":""}]},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}},{"link":{"title":"Resources","url":"/resources","target":""},"has_submenu":true,"submenu":{"submenu_type":"resources","platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":false},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":{"title":"User Stories","url":"/user-stories","target":""},"description":"Meet the leading companies who use StarTree and Apache Pinot.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/hr_slider-image-v1.png","alt":"Hr Slider Image V1","width":2400,"height":1434},"layout":"resources"},"nav":[{"link":{"title":"Blog","url":"/resources/category/blog/","target":""},"description":"Explore articles, guides, \u0026 content.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Blog.svg","alt":"Blog","width":44,"height":44},"layout":""},{"link":{"title":"Videos","url":"/resources/category/videos/","target":""},"description":"Learn more with walkthroughs.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Video.svg","alt":"Video","width":44,"height":44},"layout":""},{"link":{"title":"Events \u0026 Webinars","url":"/resources/category/events-webinars","target":""},"description":"View webinars \u0026 upcoming events. ","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Webinars.svg","alt":"Webinars","width":44,"height":44},"layout":""},{"link":{"title":"RTA Summit","url":"https://rtasummit.startree.ai/?utm_source=StarTree\u0026utm_medium=Referral\u0026utm_campaign=rtas2025","target":"_blank"},"description":"Attend Real-Time Analytics Summit.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/12/All-star.svg","alt":"All Star","width":44,"height":44},"layout":""},{"link":{"title":"In the News","url":"/news","target":""},"description":"Read about StarTree in the news.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2025/01/news_press_icon-bkg.svg","alt":"News Press Icon Bkg","width":44,"height":44},"layout":""}]}}},{"link":{"title":"Partners","url":"/partners","target":""},"has_submenu":false,"submenu":{"submenu_type":false,"platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":false},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}},{"link":{"title":"Pricing","url":"/pricing","target":""},"has_submenu":false,"submenu":{"submenu_type":false,"platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":false},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}}]},"cta":{"heading":"Ready to deploy real-time analytics?","content":"\u003cp\u003eStart for free or book a demo with our team.\u003c/p\u003e\n","button_link":{"title":"Start for free","url":"/saas-signup","target":""},"text_link":{"title":"Book a demo","url":"/demo","target":""},"stats":[{"stat":"20,000","supporting_content":"QPS"},{"stat":"\u003c1s","supporting_content":"query latency"},{"stat":"Petabyte","supporting_content":"data scale"}]},"footer":{"footer_links":[{"heading":"Platform","nav":[{"link":{"title":"Platform Overview","url":"/products/startree-cloud","target":""}},{"link":{"title":"Anomaly Detection","url":"/products/startree-thirdeye","target":""}},{"link":{"title":"Real-Time Upserts","url":"/products/real-time-upserts","target":""}},{"link":{"title":"Tiered Storage","url":"/products/tiered-storage","target":""}},{"link":{"title":"Indexing","url":"/products/indexing","target":""}},{"link":{"title":"Multi-Stage Query Engine","url":"/products/multi-stage-query-engine","target":""}},{"link":{"title":"Autoscaling Minions","url":"/products/autoscaling-minions","target":""}},{"link":{"title":"Integrations","url":"/products/data-manager","target":""}},{"link":{"title":"Security \u0026 Compliance","url":"/security-compliance","target":""}},{"link":{"title":"Deployment Options","url":"/deployment-options","target":""}},{"link":{"title":"Partner","url":"/partners","target":""}},{"link":{"title":"Pricing","url":"/pricing","target":""}}]},{"heading":"Industries","nav":[{"link":{"title":"Financial Services","url":"/solutions/financial-services","target":""}},{"link":{"title":"Retail","url":"/solutions/retail","target":""}},{"link":{"title":"Gaming","url":"/solutions/gaming","target":""}},{"link":{"title":"Delivery \u0026 Ridesharing","url":"/solutions/delivery-and-ridesharing","target":""}},{"link":{"title":"Human Resources","url":"/solutions/human-resources","target":""}},{"link":{"title":"Healthcare","url":"/solutions/healthcare","target":""}}]},{"heading":"Use cases","nav":[{"link":{"title":"Fraud Detection","url":"/solutions/fraud-detection","target":""}},{"link":{"title":"Personalization","url":"/solutions/personalization","target":""}},{"link":{"title":"Business Metrics\u2028Monitoring","url":"/solutions/business-metrics-monitoring","target":""}}]},{"heading":"For Developers","nav":[{"link":{"title":"Docs","url":"https://dev.startree.ai/docs/","target":"_blank"}},{"link":{"title":"Support","url":"https://support.startree.ai/","target":"_blank"}},{"link":{"title":"Community","url":"https://dev.startree.ai/docs/community/","target":"_blank"}}]},{"heading":"Resources","nav":[{"link":{"title":"User Stories","url":"/user-stories","target":""}},{"link":{"title":"Blog","url":"/resources/category/blog","target":""}},{"link":{"title":"Videos","url":"/resources/category/videos","target":""}},{"link":{"title":"Glossary","url":"/glossary","target":""}},{"link":{"title":"Events \u0026 Webinars","url":"/resources/category/events-webinars","target":""}},{"link":{"title":"Fundamentals","url":"/resources/category/fundamentals","target":""}},{"link":{"title":"RTA Summit","url":"/rta-summit","target":""}},{"link":{"title":"StarTree All-Stars","url":"/all-stars","target":""}}]},{"heading":"Company","nav":[{"link":{"title":"About","url":"/about","target":""}},{"link":{"title":"Careers","url":"/careers","target":""}},{"link":{"title":"Press","url":"/news","target":""}},{"link":{"title":"Contact","url":"/contact-us","target":""}},{"link":{"title":"Legal","url":"/legal","target":""}},{"link":""}]}],"newletter":{"heading":"Get the latest updates"},"legal_links":[{"link":{"title":"Trademark Policy","url":"/startree-trademark-policy","target":""}},{"link":{"title":"Privacy Policy","url":"/privacy-policy","target":""}},{"link":{"title":"Terms of Use","url":"/terms-conditions","target":""}},{"link":{"title":"Responsible Disclosure","url":"/responsible-disclosure","target":""}}],"socials":[{"logo":"linkedin","url":"https://www.linkedin.com/company/startreedata/"},{"logo":"youtube","url":"https://www.youtube.com/startreedata"},{"logo":"x","url":"https://twitter.com/startreedata"}],"logo":{"logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/06/svg-223107605-1699873195.svg","alt":"Svg 223107605 1699873195","width":80,"height":80}},"copyright_text":"StarTree Inc. All rights reserved."},"links":{"login":{"title":"Login","url":"https://startree.cloud/login","target":"_blank"},"start_for_free":{"title":"Start for free","url":"/saas-signup/","target":""},"demo":{"title":"Book a demo","url":"/demo/","target":""}}}},"__N_SSG":true},"page":"/[...slug]","query":{"slug":["products","indexing"]},"buildId":"5E_oIdejje66pIeqN--KF","isFallback":false,"isExperimentalCompile":false,"dynamicIds":[79114,76442],"gsp":true,"scriptLoader":[]}</script></body></html>