CINXE.COM
Flexible Indexing with StarTree Cloud | StarTree
<!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/8c6d09a47686c160.css" as="style"/><link rel="stylesheet" href="/_next/static/css/8c6d09a47686c160.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/194-60806cf5287b767a.js" defer=""></script><script src="/_next/static/chunks/841-214c862850535b3a.js" defer=""></script><script src="/_next/static/chunks/pages/%5B...slug%5D-5b761dd7e507de62.js" defer=""></script><script src="/_next/static/5VoeWPJN3YzEgS3re4z0M/_buildManifest.js" defer=""></script><script src="/_next/static/5VoeWPJN3YzEgS3re4z0M/_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="Flexible indexing with StarTree Cloud" loading="lazy" width="1588" height="336" 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%2F2025%2F03%2Fflexible_indexing-hero-v1.svg&w=1920&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fflexible_indexing-hero-v1.svg&w=3840&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fflexible_indexing-hero-v1.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">Handle large aggregation queries at scale with sub-second performance</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">Automatically apply the best index for your use case</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">Faster 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-hidden_ overflow-clip bg-white pt-12 lg:pt-[120px] pb-12 lg:pb-[120px]"><div class="space-y-12 md:space-y-20 lg:space-y-[120px] container"><div class=""><div aria-hidden="true" class="pointer-events-none absolute left-[-1480px] top-[-1800px] -z-10 size-[2200px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#6F42C1_0%,_rgba(233,248,255,0.00)_100%)] lg:size-[2400px]"></div><div aria-hidden="true" class="pointer-events-none absolute bottom-[-1800px] right-[-1280px] -z-10 size-[2200px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(233,248,255,0.00)_100%)] lg:size-[2400px]"></div><div style="opacity:0;will-change:opacity"><div class="flex flex-col justify-center text-center"><div class="mb-8"><img alt="57px Finserv Logo Logo Dark" loading="lazy" width="439" height="57" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 mx-auto max-h-[26px] w-auto self-start" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F11%2F57px-finserv_logo_logo-dark.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F11%2F57px-finserv_logo_logo-dark.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F11%2F57px-finserv_logo_logo-dark.svg&w=1080&q=75"/></div><h3 class="text-h4 text-inidgo mx-auto mb-10 max-w-[700px]">Real-Time Observability of Financial Transactions Using StarTree Cloud</h3><a href="/user-stories/real-time-observability-of-financial-transactions-using-startree-cloud"><div class="text-link-m group flex items-center gap-2 justify-center text-indigo">Read the full story<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 class="mx-auto mt-14 grid max-w-[792px] gap-4 sm:grid-cols-2"><div class="flex flex-col justify-between gap-6 rounded-lg bg-white/80 p-4 ring-1 ring-sky-25/10 md:gap-7 md:rounded-xl md:p-6"><p class="text-label-s inline-flex items-center self-start rounded-full border px-2.5 py-[5px] xs:px-3 xs:py-1.5 bg-sky text-indigo border-white/50">Results</p><dl class="space-y-4 md:space-y-[22px]"><div class="flex max-w-xs gap-x-1.5 gap-y-4 text-[16px] leading-[1.12] tracking-[-0.18px] sm:gap-x-3.5 sm:text-[18px]"><dt class="text-ocean">reduction in storage costs</dt><dd class="order-first font-semibold text-indigo-900">50%</dd></div><div class="flex max-w-xs gap-x-1.5 gap-y-4 text-[16px] leading-[1.12] tracking-[-0.18px] sm:gap-x-3.5 sm:text-[18px]"><dt class="text-ocean">faster queries</dt><dd class="order-first font-semibold text-indigo-900">4x</dd></div><div class="flex max-w-xs gap-x-1.5 gap-y-4 text-[16px] leading-[1.12] tracking-[-0.18px] sm:gap-x-3.5 sm:text-[18px]"><dt class="text-ocean">spans supported in a single request</dt><dd class="order-first font-semibold text-indigo-900">100k</dd></div></dl></div><div class="flex flex-col justify-between gap-6 rounded-lg bg-white/80 p-4 ring-1 ring-sky-25/10 md:gap-7 md:rounded-xl md:p-6"><p class="text-label-s inline-flex items-center self-start rounded-full border px-2.5 py-[5px] xs:px-3 xs:py-1.5 bg-sky text-indigo border-white/50">Uses Cases</p><div class="flex flex-col gap-4"><div class="text-18 flex items-center gap-2.5"><div class="size-8 shrink-0 rounded bg-sky-400"></div><span>Observability</span></div></div></div></div></div><div class="mt-14 inline-flex w-full items-center justify-center overflow-visible"><div class="relative"><div class="safari-blur absolute inset-0 h-full w-full rounded-full bg-gradient-to-r from-grape to-river blur-[10px]"></div><div class="py-[13px]_ px-[17px]_ relative flex items-center gap-x-6 rounded-full bg-indigo"><button type="button" disabled="" class="py-3.5 pl-4 transition-opacity duration-500 cursor-not-allowed opacity-50"><div class="sr-only">Previous</div><svg xmlns="http://www.w3.org/2000/svg" width="7" height="12" viewBox="0 0 7 12" fill="none"><path d="M6 10.5L1.5 6L6 1.5" stroke="#E9F8FF" stroke-width="1.1" stroke-linecap="round" stroke-linejoin="round"></path></svg></button><div class="relative flex overflow-hidden font-mono text-[13px] uppercase leading-[1.1] tracking-[1.3px] text-sky"><div class="overflow-hidden" style="will-change:transform;transform:none">01</div>/<!-- -->02</div><button type="button" class="pr-4 transition-opacity duration-500 opacity-100"><div class="sr-only">Next</div><svg class="rotate-180" xmlns="http://www.w3.org/2000/svg" width="7" height="12" viewBox="0 0 7 12" fill="none"><path d="M6 10.5L1.5 6L6 1.5" stroke="#E9F8FF" stroke-width="1.1" stroke-linecap="round" stroke-linejoin="round"></path></svg></button></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">Add indexes instantly — no downtime, no rebuilds </h2><div class="prose w-full max-md:text-balance text-18 md:custom text-ocean" style="max-width:460px"><p>Unlike competitors, StarTree optimizes query performance on the fly as your needs evolve, without re-ingesting data. When query patterns change, simply introduce new indexes and keep moving.</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><a href="#sorted-index" class="text-label-s flex text-left transition-colors text-ocean">Sorted Index</a><a href="#range-index" class="text-label-s flex text-left transition-colors text-ocean">Range Index</a><a href="#inverted-index" class="text-label-s flex text-left transition-colors text-ocean">Inverted Index</a><a href="#geospatial-index" class="text-label-s flex text-left transition-colors text-ocean">Geospatial Index</a><a href="#bloom-filter" class="text-label-s flex text-left transition-colors text-ocean">Bloom Filter</a><a href="#timestamp-index" class="text-label-s flex text-left transition-colors text-ocean">Timestamp Index</a><a href="#sparse-index" class="text-label-s flex text-left transition-colors text-ocean">Sparse 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="Vector Index Padding Graphic V1" 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%2F2025%2F03%2Fvector_index-padding_graphic-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fvector_index-padding_graphic-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fvector_index-padding_graphic-v1.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><a target="" class=" " title="Learn more" url="/products/intelligent-partial-aggregations" href="/products/intelligent-partial-aggregations"><div class="text-link-m group flex items-center gap-2 text-indigo">Learn more<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><img alt="St Index Padding Graphic V1" 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%2F2025%2F03%2Fst_index-padding_graphic-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fst_index-padding_graphic-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fst_index-padding_graphic-v1.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="Json Index Padding Graphic V1" 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%2F2025%2F03%2Fjson_index-padding_graphic-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fjson_index-padding_graphic-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fjson_index-padding_graphic-v1.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="Text Index Padding Graphic V1" 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%2F2025%2F03%2Ftext_index-padding_graphic-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Ftext_index-padding_graphic-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Ftext_index-padding_graphic-v1.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 class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="sorted-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">Sorted Index</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Applied to a pre-sorted column, enabling efficient range queries and binary search, reducing the need for scanning unnecessary data blocks.</p> </div></div></div><img alt="Sorted Index Padding Graphic V1" 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%2F2025%2F03%2Fsorted_index-padding_graphic-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fsorted_index-padding_graphic-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fsorted_index-padding_graphic-v1.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="range-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">Range Index</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Stores min-max values for column segments, allowing fast pruning of irrelevant data during range queries.</p> </div></div></div><img alt="Range Index Padding Graphic V1" 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%2F2025%2F03%2Frange_index-padding_graphic-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Frange_index-padding_graphic-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Frange_index-padding_graphic-v1.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="inverted-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">Inverted Index</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Maps unique column values to the row IDs where they appear, allowing for fast filtering and lookups, especially on high-cardinality columns.</p> </div></div></div><img alt="Inverted Index Padding Graphic V1" 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%2F2025%2F03%2Finverted_index-padding_graphic-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Finverted_index-padding_graphic-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Finverted_index-padding_graphic-v1.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="geospatial-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">Geospatial Index</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>In Pinot, you can use the geospatial index to optimize lookups based on geospatial data. This includes geospatial data types, such as point, line, and polygon; geospatial functions for querying spatial properties and relationships; and geospatial indexing, used to process spatial operations.</p> </div></div></div><img alt="Geospatial Index Padding Graphic V1" 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%2F2025%2F03%2Fgeospatial_index-padding_graphic-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fgeospatial_index-padding_graphic-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fgeospatial_index-padding_graphic-v1.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="bloom-filter"><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">Bloom Filter</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>A Bloom filter is a space-efficient probabilistic data structure that is used to test whether an element is a member of a set. IN Pinot, Bloom filter helps prune segments that do not contain any record matching an equality predicate.</p> </div></div></div><img alt="Bloom Index Padding Graphic V1" 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%2F2025%2F03%2Fbloom_index-padding_graphic-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fbloom_index-padding_graphic-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fbloom_index-padding_graphic-v1.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="timestamp-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">Timestamp Index</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Pinot provides a timestamp index type for optimizing queries based on time series data. This data type stores value as a millisecond-long epoch value internally. Typically for analytics queries, you don’t need this low level of granularity, as scanning the data and time value conversion can result in costly implications given the big size of data. The time series index optimizes these queries.</p> </div></div></div><img alt="Timestamp Index Padding Graphic V1" 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%2F2025%2F03%2Ftimestamp_index-padding_graphic-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Ftimestamp_index-padding_graphic-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Ftimestamp_index-padding_graphic-v1.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="sparse-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">Sparse Index</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>A lightweight index that selectively indexes only a subset of data, reducing storage overhead while still enabling faster lookups. It is particularly useful for optimizing queries on large datasets where full indexing would be too costly.</p> </div></div></div><img alt="Sparse Index Padding Graphic V1" 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%2F2025%2F03%2Fsparse_index-padding_graphic-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fsparse_index-padding_graphic-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2Fsparse_index-padding_graphic-v1.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></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="44px Blinkit Logo Light" loading="lazy" width="154" height="44" 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%2F12%2F44px-blinkit_logo-light.svg&w=256&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F12%2F44px-blinkit_logo-light.svg&w=320&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F12%2F44px-blinkit_logo-light.svg&w=320&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>Blinkit uses real-time analytics [from StarTree] for three purposes: experimentation, observability, and alerting. [For] observability, we have CXO dashboards and sales dashboards built in real-time where all people — from top leadership to ground folks — can see what is happening in the business in any segment in real-time.</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="Abhinesh Hada, Engineering Manager, Blinkit" loading="lazy" width="738" height="724" 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%2F12%2FAbhinesh-Hada.png&w=750&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F12%2FAbhinesh-Hada.png&w=1920&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F12%2FAbhinesh-Hada.png&w=1920&q=75"/></div><div><div class="text-h8 text-white" style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)">Abhinesh Hada</div><div class="text-16 mt-px text-sky-200" style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)">Engineering Manager</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-[28px] md:pb-12 lg:pb-20"><div class="space-y-12 md:space-y-20 lg:space-y-[120px] container"><div class="overflow-hidden_"><h4 class="text-label-l text-ocean">resources for Flexible Indexing</h4><div class="swiper !mx-0 mt-9 !overflow-visible will-change-transform"><div class="swiper-wrapper"><div class="swiper-slide"><article class="relative isolate overflow-hidden rounded-xl bg-[#F1FAFF] p-[19px] lg:p-7 xs:aspect-[259/289] lg:aspect-[384/428]"><img alt="1684246766-image4" loading="lazy" width="1600" height="730" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 !absolute inset-0 -z-10 h-full w-full object-cover blur" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F1684246766-image4.png&w=1920&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F1684246766-image4.png&w=3840&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F1684246766-image4.png&w=3840&q=75"/><div class="absolute inset-0 bottom-0 z-10 bg-gradient-to-b from-[#00152E]/90 to-[#00152E]/40"></div><div class="relative z-20 flex h-full flex-col justify-between overflow-hidden max-xs:min-h-[320px]"><div><div class="flex items-center gap-3"><p class="text-label-s inline-flex items-center self-start rounded-full border px-2.5 py-[5px] xs:px-3 xs:py-1.5 bg-white/15 text-white border-white/25">Blog</p></div><h3 class="mt-[14px] md:mt-5 text-white text-h6 lg:max-w-[280px]"><a class="cta-button" target="" href="/resources/star-tree-indexes-in-apache-pinot-part-1-understanding-the-impact-on-query-performance"><span class="absolute inset-0"></span>Star-Tree Indexes in Apache Pinot - Part 1: Understanding the Impact on Query Performance</a></h3></div><div class="mb-0.5"><div class="text-link-m flex items-center gap-2 text-white"><div class="flex items-center gap-2" style="will-change:transform;transform:translateX(-91%)"><span style="opacity:0;will-change:opacity">Read article</span><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="text-white w-2.5" 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></div></div></div></div><div aria-hidden="true" class="pointer-events-none absolute left-[-250px] top-[-250px] -z-10 size-[468px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#FFE8A5_0%,_rgba(242,251,255,0.00)_100%)]"></div><div aria-hidden="true" class="pointer-events-none absolute bottom-[-500px] right-[-580px] -z-10 size-[937px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#7ADDEA_0%,_rgba(242,251,255,0.00)_100%)]"></div></article></div><div class="swiper-slide"><article class="relative isolate overflow-hidden rounded-xl bg-[#F1FAFF] p-[19px] lg:p-7 xs:aspect-[259/289] lg:aspect-[384/428]"><img alt="1690821638-delta-lake-blog_preview-v1.png" loading="lazy" width="1920" height="1080" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 !absolute inset-0 -z-10 h-full w-full object-cover blur" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F1690821638-delta-lake-blog_preview-v1.png&w=1920&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F1690821638-delta-lake-blog_preview-v1.png&w=3840&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F1690821638-delta-lake-blog_preview-v1.png&w=3840&q=75"/><div class="absolute inset-0 bottom-0 z-10 bg-gradient-to-b from-[#00152E]/90 to-[#00152E]/40"></div><div class="relative z-20 flex h-full flex-col justify-between overflow-hidden max-xs:min-h-[320px]"><div><div class="flex items-center gap-3"><p class="text-label-s inline-flex items-center self-start rounded-full border px-2.5 py-[5px] xs:px-3 xs:py-1.5 bg-white/15 text-white border-white/25">Blog</p></div><h3 class="mt-[14px] md:mt-5 text-white text-h6 lg:max-w-[280px]"><a class="cta-button" target="" href="/resources/indexing-101-with-apache-pinot"><span class="absolute inset-0"></span>Indexing 101 with Apache Pinot™</a></h3></div><div class="mb-0.5"><div class="text-link-m flex items-center gap-2 text-white"><div class="flex items-center gap-2" style="will-change:transform;transform:translateX(-91%)"><span style="opacity:0;will-change:opacity">Read article</span><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="text-white w-2.5" 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></div></div></div></div><div aria-hidden="true" class="pointer-events-none absolute left-[-250px] top-[-250px] -z-10 size-[468px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#FFE8A5_0%,_rgba(242,251,255,0.00)_100%)]"></div><div aria-hidden="true" class="pointer-events-none absolute bottom-[-500px] right-[-580px] -z-10 size-[937px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#7ADDEA_0%,_rgba(242,251,255,0.00)_100%)]"></div></article></div><div class="swiper-slide"><article class="relative isolate overflow-hidden rounded-xl bg-[#F1FAFF] p-[19px] lg:p-7 xs:aspect-[259/289] lg:aspect-[384/428]"><img alt="1689174278-delta-lake-blog_preview-v1.png" loading="lazy" width="1920" height="1080" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 !absolute inset-0 -z-10 h-full w-full object-cover blur" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F1689174278-delta-lake-blog_preview-v1.png&w=1920&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F1689174278-delta-lake-blog_preview-v1.png&w=3840&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F1689174278-delta-lake-blog_preview-v1.png&w=3840&q=75"/><div class="absolute inset-0 bottom-0 z-10 bg-gradient-to-b from-[#00152E]/90 to-[#00152E]/40"></div><div class="relative z-20 flex h-full flex-col justify-between overflow-hidden max-xs:min-h-[320px]"><div><div class="flex items-center gap-3"><p class="text-label-s inline-flex items-center self-start rounded-full border px-2.5 py-[5px] xs:px-3 xs:py-1.5 bg-white/15 text-white border-white/25">Blog</p></div><h3 class="mt-[14px] md:mt-5 text-white text-h6 lg:max-w-[280px]"><a class="cta-button" target="" href="/resources/star-tree-index-in-apache-pinot-part-3-understanding-the-impact-in-real-customer"><span class="absolute inset-0"></span>Star-Tree Index in Apache Pinot - Part 3: Understanding the Impact in Real Customer Scenarios</a></h3></div><div class="mb-0.5"><div class="text-link-m flex items-center gap-2 text-white"><div class="flex items-center gap-2" style="will-change:transform;transform:translateX(-91%)"><span style="opacity:0;will-change:opacity">Read article</span><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="text-white w-2.5" 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></div></div></div></div><div aria-hidden="true" class="pointer-events-none absolute left-[-250px] top-[-250px] -z-10 size-[468px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#FFE8A5_0%,_rgba(242,251,255,0.00)_100%)]"></div><div aria-hidden="true" class="pointer-events-none absolute bottom-[-500px] right-[-580px] -z-10 size-[937px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#7ADDEA_0%,_rgba(242,251,255,0.00)_100%)]"></div></article></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-[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>We’re here to help!</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="/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 py-3 md:px-8 md:py-4 text-link-m bg-turmeric text-indigo"><div>Get in Touch</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></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]"><div><img alt="80px Footer Logos V1" loading="lazy" width="426" 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%2F2025%2F03%2F80px-footer_logos-v1.png&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2F80px-footer_logos-v1.png&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2025%2F03%2F80px-footer_logos-v1.png&w=1080&q=75"/></div><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":"2025-03-04 16:07:34","post_modified_gmt":"2025-03-04 16:07:34","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/2025/03/flexible_indexing-hero-v1.svg","alt":"Flexible indexing with StarTree Cloud","width":1588,"height":336}}},"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":"Handle large aggregation queries at scale with sub-second performance","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":"Automatically apply the best index for your use case","content":"\u003cp class=\"p1\"\u003eFrom vector and geospatial, to JSON and text, choose from 11 index types to optimize performance for your specific analytics needs — whether it’s real-time monitoring or complex ad-hoc queries.\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":"Faster query performance with dynamic tuning","content":"\u003cp class=\"p1\"\u003eIdentify and optimize slow queries automatically. Add or modify indexes on any column without downtime, instantly improving performance based on your evolving query patterns.\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’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":"resources","resources":[{"acf_fc_layout":"detailed_customer_slider","posts":[{"ID":6259,"post_title":"Real-Time Observability of Financial Transactions Using StarTree Cloud","permalink":"/user-stories/real-time-observability-of-financial-transactions-using-startree-cloud","acf":{"preview":{"theme":"yellow_blue"},"logos":{"light_logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/11/57px-finserv_logo-light.svg","alt":"57px Finserv Logo Light","width":439,"height":57},"dark_logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/11/57px-finserv_logo_logo-dark.svg","alt":"57px Finserv Logo Logo Dark","width":439,"height":57}},"stats":{"stats":[{"stat":"50%","supporting_content":"reduction in storage costs","supporting_content_short":"decrease in costs"},{"stat":"4x","supporting_content":"faster queries"},{"stat":"100k","supporting_content":"spans supported in a single request","supporting_content_short":"spans in a request"}]}},"use_case":[{"id":42,"name":"Observability","slug":"observability"}],"industry":[{"id":39,"name":"Financial Services","slug":"financial-services"}]},{"ID":4355,"post_title":"Dialpad Powers Real-Time Customer Intelligence with StarTree Cloud","permalink":"/user-stories/dialpad-powers-real-time-customer-intelligence-with-startree-cloud","acf":{"preview":{"thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/The-Dialpad-product-is-an-AI-powered-platform.png","alt":"The Dialpad product is an AI powered platform","width":1200,"height":630},"heading":"Dialpad Powers Real-Time Intelligence with StarTree","theme":"yellow_blue"},"logos":{"light_logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/48px-dialpad_logo-light.svg","alt":"48px Dialpad Logo Light","width":205,"height":48},"dark_logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/48px-dialpad_logo-dark.svg","alt":"48px Dialpad Logo Dark","width":205,"height":48}},"stats":{"stats":[{"stat":"10,000s","supporting_content":"of live users"},{"stat":"500 ms","supporting_content":"p95 latencies"},{"stat":"98%","supporting_content":"lower latencies"}]}},"use_case":[{"id":7,"name":"Business Metrics Monitoring","slug":"business-metrics-monitoring","acf":{"icon":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Analytics.svg","alt":"Analytics","width":32,"height":32}}}],"industry":[{"id":34,"name":"Telecommunications","slug":"telecommunications"}]}]}]}],"padding_top":"120","padding_bottom":"120","inner_spacing":"120","has_container":true,"background":{"background_color":"white"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"text_card","text_card":{"heading":"Add indexes instantly — no downtime, no rebuilds ","content":"\u003cp\u003eUnlike competitors, StarTree optimizes query performance on the fly as your needs evolve, without re-ingesting data. When query patterns change, simply introduce new indexes and keep moving.\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/2025/03/vector_index-padding_graphic-v1.svg","alt":"Vector Index Padding Graphic V1","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","link":{"title":"Learn more","url":"/products/intelligent-partial-aggregations"},"asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2025/03/st_index-padding_graphic-v1.svg","alt":"St Index Padding Graphic V1","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/2025/03/json_index-padding_graphic-v1.svg","alt":"Json Index Padding Graphic V1","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/2025/03/text_index-padding_graphic-v1.svg","alt":"Text Index Padding Graphic V1","width":464,"height":460}}},"theme":"green_grey"},{"label":"Sorted Index","heading":"Sorted Index","content":"\u003cp\u003eApplied to a pre-sorted column, enabling efficient range queries and binary search, reducing the need for scanning unnecessary data blocks.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2025/03/sorted_index-padding_graphic-v1.svg","alt":"Sorted Index Padding Graphic V1","width":464,"height":460}}},"theme":"green_blue"},{"label":"Range Index","heading":"Range Index","content":"\u003cp\u003eStores min-max values for column segments, allowing fast pruning of irrelevant data during range queries.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2025/03/range_index-padding_graphic-v1.svg","alt":"Range Index Padding Graphic V1","width":464,"height":460}}},"theme":"green_blue"},{"label":"Inverted Index","heading":"Inverted Index","content":"\u003cp\u003eMaps unique column values to the row IDs where they appear, allowing for fast filtering and lookups, especially on high-cardinality columns.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2025/03/inverted_index-padding_graphic-v1.svg","alt":"Inverted Index Padding Graphic V1","width":464,"height":460}}},"theme":"green_blue"},{"label":"Geospatial Index","heading":"Geospatial Index","content":"\u003cp\u003eIn Pinot, you can use the geospatial index to optimize lookups based on geospatial data. This includes geospatial data types, such as point, line, and polygon; geospatial functions for querying spatial properties and relationships; and geospatial indexing, used to process spatial operations.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2025/03/geospatial_index-padding_graphic-v1.svg","alt":"Geospatial Index Padding Graphic V1","width":464,"height":460}}},"theme":"green_blue"},{"label":"Bloom Filter","heading":"Bloom Filter","content":"\u003cp\u003eA Bloom filter is a space-efficient probabilistic data structure that is used to test whether an element is a member of a set. IN Pinot, Bloom filter helps prune segments that do not contain any record matching an equality predicate.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2025/03/bloom_index-padding_graphic-v1.svg","alt":"Bloom Index Padding Graphic V1","width":464,"height":460}}},"theme":"green_blue"},{"label":"Timestamp Index","heading":"Timestamp Index","content":"\u003cp\u003ePinot provides a timestamp index type for optimizing queries based on time series data. This data type stores value as a millisecond-long epoch value internally. Typically for analytics queries, you don’t need this low level of granularity, as scanning the data and time value conversion can result in costly implications given the big size of data. The time series index optimizes these queries.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2025/03/timestamp_index-padding_graphic-v1.svg","alt":"Timestamp Index Padding Graphic V1","width":464,"height":460}}},"theme":"green_blue"},{"label":"Sparse Index","heading":"Sparse Index","content":"\u003cp\u003eA lightweight index that selectively indexes only a subset of data, reducing storage overhead while still enabling faster lookups. It is particularly useful for optimizing queries on large datasets where full indexing would be too costly.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2025/03/sparse_index-padding_graphic-v1.svg","alt":"Sparse Index Padding Graphic V1","width":464,"height":460}}},"theme":"green_blue"}]}]}],"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":7724,"post_title":"Blinkit — Abhinesh Hada","acf":{"quote":"\u003cp\u003eBlinkit uses real-time analytics [from StarTree] for three purposes: experimentation, observability, and alerting. [For] observability, we have CXO dashboards and sales dashboards built in real-time where all people — from top leadership to ground folks — can see what is happening in the business in any segment in real-time.\u003c/p\u003e\n","job_role":"Engineering Manager","logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/12/44px-blinkit_logo-dark.svg","alt":"44px Blinkit Logo Dark","width":154,"height":44},"inverted_logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/12/44px-blinkit_logo-light.svg","alt":"44px Blinkit Logo Light","width":154,"height":44},"avatar":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/12/Abhinesh-Hada.png","alt":"Abhinesh Hada, Engineering Manager, Blinkit","width":738,"height":724},"name":"Abhinesh Hada"}}],"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":"resources","resources":[{"acf_fc_layout":"preview_three_column","subheading":"resources for Flexible Indexing","posts":[{"ID":1989,"post_title":"Star-Tree Indexes in Apache Pinot - Part 1: Understanding the Impact on Query Performance","permalink":"/resources/star-tree-indexes-in-apache-pinot-part-1-understanding-the-impact-on-query-performance","categories":[{"id":3,"name":"Blog","slug":"blog"}],"acf":{"preview":{"thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/1684246766-image4.png","alt":"1684246766-image4","width":1600,"height":730},"theme":"yellow_blue"},"layout":"post"}},{"ID":1894,"post_title":"Indexing 101 with Apache Pinot™","permalink":"/resources/indexing-101-with-apache-pinot","categories":[{"id":3,"name":"Blog","slug":"blog"}],"acf":{"preview":{"thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/1690821638-delta-lake-blog_preview-v1.png","alt":"1690821638-delta-lake-blog_preview-v1.png","width":1920,"height":1080},"theme":"yellow_blue"},"layout":"post"}},{"ID":1914,"post_title":"Star-Tree Index in Apache Pinot - Part 3: Understanding the Impact in Real Customer Scenarios","permalink":"/resources/star-tree-index-in-apache-pinot-part-3-understanding-the-impact-in-real-customer","categories":[{"id":3,"name":"Blog","slug":"blog"}],"acf":{"preview":{"thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/1689174278-delta-lake-blog_preview-v1.png","alt":"1689174278-delta-lake-blog_preview-v1.png","width":1920,"height":1080},"theme":"yellow_blue"},"layout":"post"}}]}]}],"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":"Intelligent Partial Aggregations","url":"/products/intelligent-partial-aggregations","target":""},"description":"Run 95% faster queries.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2025/03/st_index_icon-bkg.svg","alt":"St Index Icon Bkg","width":44,"height":44},"layout":""},{"link":{"title":"Flexible 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\u003eWe\u0026#8217;re here to help!\u003c/p\u003e\n","button_link":{"title":"Get in Touch","url":"/demo","target":""},"text_link":"","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/2025/03/80px-footer_logos-v1.png","alt":"80px Footer Logos V1","width":426,"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":"5VoeWPJN3YzEgS3re4z0M","isFallback":false,"isExperimentalCompile":false,"dynamicIds":[79114,76442],"gsp":true,"scriptLoader":[]}</script></body></html>