AI Hardware Demand Growth and Representative US-Listed Companies June 2026 Executive Summary Nvidia’s transition to the Vera Rubin (VR200) platform marks a significant escalation in AI infrastructure complexity and cost. Our BOM teardown of the next-generation Rubin rack reveals a ~2x increase in total rack cost to approximately $7.8 million (vs. ~$4 million for GB300), driven not solely by the GPU/CPU but by sharp revaluations across the supply chain. Key highlights from downstream components include: • PCB content value +233% YoY, the largest increase. • MLCC +182%, reflecting higher density and count (e.g., ~600k MLCCs per VR200 NVL72 server, +30%+ vs. GB300). • ABF substrates +82%, power solutions +32%, and liquid cooling +12%. These upgrades align with broader AI scaling: 800G/1.6T optical transceivers ramping aggressively, glass-based technologies advancing for packaging and interconnects, and hyperscalers prioritizing performance, power efficiency, and thermal management. We expect sustained multi-year tailwinds for the AI hardware ecosystem into 2027+, with Rubin-driven demand accelerating in H2 2026. Investment Thesis: While Nvidia (NVDA) remains the core beneficiary, the supply chain offers diversified exposure. We favor companies with direct exposure to high-growth areas like advanced PCBs, high-speed optics, and glass substrates/optical interconnects. Risks include execution on new capacity, potential margin pressure from rapid scaling, and geopolitical supply chain factors. 1. PCB: Sharpest Value Uplift in Rubin BOM Morgan Stanley’s detailed analysis shows PCB content in the Rubin rack surging +233% versus GB300. This reflects needs for higher layer counts, advanced materials, better signal integrity, and larger formats to support increased power and interconnect density in AI servers. US Representative: TTM Technologies (TTMI) – Leading US PCB manufacturer with strong positioning in high-complexity boards for data center/AI applications. TTM has invested in capacity expansions (e.g., new facilities) to capture AI-driven demand for advanced HDI and high-layer PCBs. 2. MLCC: Density-Driven Surge Nvidia’s VR200 NVL72 platform requires ~600,000 MLCCs per server, over 30% more than GB300. Combined with the +182% value increase in the BOM, this underscores tightening supply for high-capacitance, high-reliability MLCCs in power delivery and decoupling for AI accelerators. Exposure Note: The MLCC market is dominated by Asian players (e.g., Murata, Samsung Electro-Mechanics, Yageo). US-listed indirect exposure may come through broader electronics or power solution providers, but direct pure-play opportunities are limited. Watch for capacity utilization tightness benefiting the ecosystem. 3. Optical Communication: 800G/1.6T Ramp Accelerating Chinese leader Zhongji Innolight reported Q1 2026 net profit +262% YoY, driven by strong 800G/1.6T shipments, with expectations of significant full-year growth. This mirrors industry-wide momentum as AI clusters shift toward higher-speed optics for reduced latency and power in scale-out/scale-up networking. Nvidia’s investments in photonics and CPO further validate the trend. US Representatives: • Coherent (COHR) and Lumentum (LITE): Key players in optical components and transceivers; Nvidia has made substantial equity investments to secure capacity. • Corning (GLW): Major beneficiary via optical fiber, connectivity, and glass technologies (detailed below). 4. Micro-LED/Glass Substrates & Optical Interconnects: Strategic Partnerships Accelerating On May 20, 2026, BOE announced a cooperation MOU with Corning covering glass-based encapsulation carriers, foldable glass, perovskite substrates, and optical interconnect applications. This aligns with industry shifts toward glass cores for superior flatness, thermal stability, and integration in advanced packaging and photonics—critical for next-gen AI as organic substrates hit limits. US Representative: Corning (GLW) – Central to Nvidia’s optical strategy with multi-billion partnerships, new US optical factories, and expansion in fiber/photonics for AI data centers. Recent deals position GLW for 10x+ capacity growth in key areas. AI Hardware Demand Growth & US-Listed Representative Companies Table Component Demand Growth (vs. GB300) Key Drivers US-Listed Reps Investment Rationale PCB +233% value Higher layers, HDI, signal integrity TTM Technologies (TTMI) Direct AI server/backplane exposure; US capacity expansion MLCC +182% value; +30%+ count Power density in servers Limited direct (ecosystem via power suppliers) Supply tightness supports pricing/volume Optical Comm (800G/1.6T) Strong ramp (e.g., +262% profit ex.) Scale-out networking, CPO transition Coherent (COHR), Lumentum (LITE), Corning (GLW) Nvidia investments; transceiver/fiber boom Glass Substrates/Interconnects Emerging (MOU-driven) Packaging, photonics, thermal/optical Corning (GLW) Nvidia factory deals; US manufacturing tailwinds Power & Liquid Cooling +32% / +12% Higher TDP (e.g., 2300W GPUs) Indirect (ecosystem) Secondary but critical for rack deployment Source: Morgan Stanley BOM analysis, company reports, industry data. Growth metrics approximate from Rubin teardown. Outlook & Risks We project robust 2026-2027 growth in AI capex, with Rubin shipments catalyzing another leg-up in component demand. Optical and advanced substrate shifts could extend the cycle beyond traditional GPU focus. Hyperscalers’ vertical integration and US onshoring (e.g., Corning/Nvidia factories) add resilience. Key Risks: Cyclical capex pauses, yield/execution challenges on new tech (glass/CPO), commodity volatility in passives, and intense competition in Asia-heavy segments. Valuation multiples in the space have expanded; selectivity is key. Recommendation: Overweight select supply chain names with strong Nvidia alignment (e.g., TTMI for PCBs, COHR/LITE/GLW for optics/glass). Monitor Q2 2026 earnings for confirmation of Rubin ramp momentum.

📈 US Market Pre-Market Intelligence | June 3, 2026 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Sources: CNBC · Benzinga · StockTwits · The Motley Fool · TheStreet Pro · Reuters · Bloomberg · LSEG · FTSE Russell · · Yahoo Finance · The Globe and Mail Data window: Past 24h (priority: past 12h) ━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 【Market Snapshot】 • S&P 500 Futures: -0.3% | Nasdaq futures: +0.4% • VIX: 15.77 (1-year low, neutral-low) • Fear & Greed: 66 (Greed zone) • WTI Crude: ~$93/barrel (Iran tensions supporting) • Dollar Index: DXY 107.2 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 【SECTION 1: TOP NEWS — TECH/AI/SEMICONDUCTOR】 🔥 Jensen Huang at GTC Taipei (June 2-3, 2026): The Single Biggest Catalyst ━━━━━━━━━━━━━━━━━━━━ Source: The Motley Fool · StockTwits · Bloomberg · Reuters · Yahoo Finance · BigGo Finance · Times of India · DataCenterNews Asia 1. MRVL +32.5% Tuesday → all-time high. Huang on stage: "Matt [Murrett] is building the next trillion-dollar company." MRVL premarket today: +22%. → Custom AI chips (non-NVDA) = the new AI alpha. Gary Black (top Tesla/tech fund manager): "Broadcom and Marvell are the big winners as focus shifts to custom AI ASICs." 2. AVGO + Broadcom: Hit 52-week high alongside MRVL. Custom AI networking/DPU chips gaining enterprise share. Gary Black: AVGO is a "big winner" in the custom chip shift. 3. HPE Hewlett Packard Enterprise: Hit 52-week high premarket. Analyst (StockTwits): "AI-driven quarter — shares deserve a higher multiple." Aruba/AI infrastructure backlog strong. 4. NVIDIA Vera Rubin platform: Full production announced at GTC Taipei today (June 3). Next-gen AI data center GPU. NVDA stock slightly lower premarket (-0.5%) as markets digest the rally in competitors MRVL/AVGO. 5. TSMC ADR hit record high +2.5%. Deepened NVIDIA partnership confirmed at GTC Taipei. Philadelphia Semiconductor Index (SOX) surged 5.9% to all-time peak — biggest single-day move in 2026. 6. IPG Photonics, MACOM, Amkor: All skyrocketed after Huang's GTC Taipei keynote. AI photonics + advanced packaging = next bottleneck. 7. Trump Executive Order: Government gets early access to advanced AI models. StockTwits called it "pro-AI infrastructure" signal. Microsoft + NVIDIA partnership: RTX Spark + Vera CPU for Windows AI laptops. Build 2026 event this week. 8. MU Micron: UBS upgraded to $1625 target — more than 100% upside. HBM memory demand = structural supercycle. ⚠️ Warning Signal: Michael Burry (The Big Short): AI chip rally is within 7% of 2000 dot-com bubble peak. Chart suggests caution on AI momentum names. Retail vs. institutional positioning diverging. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 【SECTION 2: RETAIL SENTIMENT — STOCKTWITS/TRADINGVIEW/WALLSTREETBETS】 Source: StockTwits · TradingView News · TheStreet Pro · Yahoo Finance ━━━━━━━━━━━━━━━━━━━━ 📊 Most-discussed tickers by retail (past 24h): • MRVL: Trending #1# on StockTwits. Retail piling in after Huang shoutout. Bullish comments dominate. "MRVL to $200" comments everywhere. • AVGO: Custom chip theme driving retail interest. "This is the NVDA of 2026" sentiment growing. • ASTS (AST SpaceMobile): Snapped 2-day losing streak. Top execs buying shares = vote of confidence. SpaceX IPO buzz creating turbulence but long-term thesis intact. Retail mostly bullish. • RKLB / LUNR / RDW: Slipping on SpaceX IPO speculation. Bears say SpaceX could cannibalize launch demand. Bulls watching. • META: Retail sees buying opportunity. Stock still trails Mag 7 peers despite new subscriptions + layoffs + cloud plans. "META cheap vs. GOOGL/AMZN" sentiment. • TSLA: Dips on SpaceX merger rumors. Retail influencer: "Bull case adds $450B to valuation." SpaceX IPO terms uncertainty weighing. • INTC Intel: Surprising surge today. Investors asking "why is Intel surging?" AI PC + foundry turnaround narrative returning. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 【SECTION 3: MARKET THEMES — AI ROTATION + SMALL CAP BREAKOUT】 Source: The Globe and Mail · 247WallSt · Benzinga · AInvest · TheStreet Pro · LSEG ━━━━━━━━━━━━━━━━━━━━ 🚀 AI Money Rotating from Mega-Cap → Small/Mid Cap: • Small caps are AI's big winners in 2026 (The Globe and Mail, Reuters, 10 hours ago) • Russell 2000 small-cap value has beaten growth by 9 percentage points YTD • Something rare is driving the Russell 2000 — and AI is the answer (Benzinga) • AI exuberance rotating into small caps amid sticky inflation (ActionForex) • IWM, VTWO, URTH all flashing strong buy signals (MarketsHost) 📊 Russell 2000 reconstitution underway (FTSE Russell, May 22 announcement): Total US equity market cap in Russell 3000 reached $75.6 trillion — 29% increase from prior year. Major index changes creating volatility + opportunities. 💰 Sector rotation: Energy (oil $93, Iran) + AI semis + small-cap value = today's leadership. Defensive sectors (utilities, consumer staples) outflowing. ⚡ Middle East: Oil supported at $90-95 range. US-Iran tensions escalating (missiles launched toward Kuwait/Bahrain per fxstreet). Energy stocks (XOM, CVX) get tailwind. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 【SECTION 4: KEY STOCKS — PREMIER DATA FROM AUTHORITATIVE SOURCES】 Source: StockTwits · The Motley Fool · Yahoo Finance · Benzinga · TheStreet Pro ━━━━━━━━━━━━━━━━━━━━ 🔥 MRVL — Marvell Technology Price: ~$140+ (premarket +22%) | 52-week HIGH Catalyst: Jensen Huang at GTC Taipei: "next trillion-dollar company" Analyst: Gary Black — "big winner" in custom AI chip theme Analyst: Morgan Stanley sees $120+ target Narrative: AI custom ASIC for cloud. Google's TPUSnake, Amazon's Trainium = MRVL customers. Data center custom silicon = secular trend. Risk: Rich valuation. PS 20x. Momentum + Huang boost = near-term overbought. 📊 AVGO — Broadcom Price: ~$220+ | 52-week HIGH Catalyst: Custom AI networking chips + VMware synergy Narrative: #2# AI chip play after NVDA. Custom DPUs + networking for AI data centers. Gary Black: "big winner" alongside MRVL Risk: Valuation already pricing in strong growth 🚀 HPE — Hewlett Packard Enterprise Price: premarket +strong | 52-week HIGH Catalyst: AI-driven quarter beat. Aruba networking + GreenLake AI services. Analyst quote (StockTwits): "AI quarter — shares deserve higher multiple" Narrative: AI infrastructure + edge computing + hybrid cloud = multi-year growth Risk: Competition from Dell/Arista in AI networking 💡 TSMC — Taiwan Semiconductor ADR Price: $446.69 (+2.5% record high) Catalyst: NVIDIA partnership deepened at GTC Taipei. Advanced node capacity = structural moat. Narrative: Foundry king. AI compute demand = capacity fully booked for 2026-2027 Risk: Taiwan geopolitical risk premium always present ⚡ IPG Photonics / MACOM / Amkor Price: all skyrocketed after GTC Taipei keynote Catalyst: AI photonics (laser/optical interconnect) + advanced packaging (Amkor = chiplet packaging) Narrative: AI hardware bottleneck shifting from compute → interconnect + packaging Risk: Volatile momentum names ━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 【SECTION 5: SMALL-CAP US ALPHA 🔍】 Serenity Framework: Demand → Earnings → Small-Cap Elasticity → Verification ━━━━━━━━━━━━━━━━━━━━ 📌 IWM — iShares Russell 2000 ETF | Small-Cap Core Trigger: Russell 2000 hit strong buy signals; small-cap value beating growth by 9pts YTD; AI rotation into small caps confirmed (The Globe and Mail) Elasticity: Russell 2000 constituents with AI exposure = leverage to sector rotation Verification: FTSE Russell reconstitution underway; IWM options volume surging Catalyst: ADP jobs data today; Fed speakers this week; Russell reconstitution culminates end of June Risk: Rate sensitivity if jobs data hot → delay Fed cuts → small caps hurt 📌 FLNC — Fluence Energy | AI Data Center Cooling Trigger: Jensen Huang GTC keynote emphasized AI data center infrastructure at scale. Cooling/power = next bottleneck as compute density explodes. Elasticity: AI data centers need liquid cooling at scale — FLNC is leader in modular battery/cooling systems Verification: Stock up strongly post-GTC keynote. Institutional buying volume rising. Catalyst: Next earnings — watch backlog. If backlog grows >40% YoY = confirm supercycle thesis. Risk: Competition from Schneider Electric / Vertiv 📌 SOXL — Direxion Daily Semiconductor Bull 3X Trigger: Philadelphia Semiconductor Index +5.9% to all-time high. TSMC record. MRVL +32%. AI chip theme = institutional inflow. Elasticity: 3x leveraged ETF = amplified move in semiconductor sector Verification: SOXL options activity spiking. Retail interest elevated (StockTwits trending). Catalyst: Any NVIDIA/AMD/MU earnings beat = SOXL pops 5-8% same day Risk: 3x leverage = decay risk. Only for short-term tactical use. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 【SECTION 6: MACRO + MARKET STRUCTURE】 Source: Bloomberg · Reuters · fxstreet · LSEG · FTSE Russell ━━━━━━━━━━━━━━━━━━━━ 📅 Today's Key Events (June 3, 2026): • ADP Private Sector Employment (May) — consensus: +180K • ISM Services PMI (May) — flash PMI showed expansion, services follow-up • EIA Weekly Crude Inventory • Fed speakers: likely to maintain data-dependent stance • GTC Taipei keynote continues (NVIDIA ecosystem announcements) ⚠️ Key Risks: 1. Iran/Middle East escalation → oil spike >$95 → inflation risk → Fed hawkish 2. AI chip rally froth (Burry warning) → sector could see sharp 5-10% correction 3. SpaceX/OpenAI/Anthropic IPO timeline: Standard Chartered warns "market oxygen being sucked out" when these hit 4. Tariff fatigue: Section 301 tariffs on 60 economies (forced labor) could hit supply chains 5. MU/TSMC: Any supply disruption from Taiwan Strait tension = semiconductor sector crash ━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 【SECTION 7: INSTITUTIONAL FLOWS】 Source: LSEG · FTSE Russell · Bloomberg ━━━━━━━━━━━━━━━━━━━━ • AI/Infrastructure: MRVL, AVGO, HPE, TSM — HEAVY institutional accumulation • Energy: XOM, CVX — inflows on oil geopolitics premium • Small-cap value: IWM, VTWO — first real institutional rotation signal of 2026 • Outflows: Utilities (XLU), Consumer Staples (XLP), REITs — rate sensitivity • Crypto/Fintech: COIN, SQ — mixed; Bitcoin holding $95K support ━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 【INVESTMENT SUMMARY — 3 Scenarios】 🔵 Bull Case: AI custom chip theme continues → MRVL/AVGO/TSM lead → small caps catch fire → Russell 2000 breaks out → IWM $250+ Catalyst: MU earnings beat, AMD data center beat, ADP jobs soft (Fed cuts priced in) 🔴 Bear Case: Burry warning correct → AI chip rally peaks → MRVL/AVGO reverse → Nasdaq -3% correction Catalyst: Strong ADP + hot inflation → rate cut timeline pushed out → small caps get crushed 🟡 Base Case: AI infrastructure secular bull → semis consolidate at high level → small caps rotate in/out in tranches → VIX stays 15-18 Catalyst: No major catalyst → range-bound S&P 500 with sector divergence ━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ⚠️ Disclaimer: This content is for informational purposes only and does not constitute investment advice. Data sourced from public English-language financial media (CNBC, Bloomberg, Reuters, StockTwits, Benzinga, The Motley Fool, TheStreet, LSEG). Historical performance does not guarantee future results. Consult a licensed financial advisor before investing.

👀 #MediaTek# confirms its AI ASIC collaboration with #Intel’s# EMIB-T advanced packaging. The chipmaker is now pushing 400G SerDes IP to target next-gen ASIC opportunities, including reportedly #Google’s# TPU v10 and Meta’s custom AI chips.💡More: 🔗

NVIDIA JUST CONFIRMED ITS NEXT-GEN CHIPS ARE ON SCHEDULE, AND MADE A DIRECT COMPARISON TO AMD IN THE SAME BREATH Nvidia $NVDA says its chips remain on track for use in AI data centers. The company also says its new Vera processor is faster than AMD's Turin. Nvidia said a major customers are already testing Vera Rubin hardware.

Chris Camillo tells Gen Z to skip college to become a hyper-proficient AI specialist "If you're just a regular and young person, spend 6 months becoming a top 1% person in AI by self-learning" "Go where wealthy business owners hang out. I don't care if it's a conference in Vegas, go to the hotel bar and start walking up to old guys who are likely business owners or C-level execs" "Introduce yourself and say, I just spent 6 months becoming hyper-proficient at using bleeding-edge AI tools to solve problems. Over the next 3 years, your business is going to have so many issues and I'll be able to solve them for pennies on the dollar" "I don't know how many people you have in your company who are hyper-proficient in AI right now. But I am. Can we talk?" "Have that conversation over and over until one of them goes, I don't even know what I'm going for use you for, but we're hiring you next week"

Lt Gen MU Nair (Retd), Former National Cyber Security Coordinator, delivered an insightful lecture on "Cyber Warfare in India" to Student Officers of #DSTSC09#, and #MPCTC78#, including officers from Friendly Foreign Countries at #MILIT#. He underscored that future conflicts will be shaped by superiority in information, data, networks and decision-making. Emphasising cyber sovereignty, resilient digital infrastructure, AI and trusted communications, he highlighted the critical role of cyber capabilities in the evolving multi-domain battlespace. @DefenceMinIndia @SethSanjayMP @SpokespersonMoD @MIB_India #ProfessionalMilitaryEducation#

Just a semi recap TLDR: - $GLW glass bridge per Morgan Stanley has potential, but hard to displace FAU (like FOCI) in short term - $SPCX Starlink Gen 3 is scaling to 100,000 units (10x prev gen) creating possible capacity constraints for suppliers of switches to CCL. - PCB supply shortages are projected to persist until 2028, and component shortages/price hikes are already forcing ODMs like Inventec to issue conservative H2 shipment - DeepSeek and Zhipu are developing custom ASICs to bypass $NVDA (kinda expected by now). - Anthropic has achieved a $30B ARR and is projected to hit >$1B in Q3 profit. Turns out these frontier labs are more profitable than people think. - US admin pressured $AAPL to source from $INTC, in exchange for tariff exception. Kinda pressuring alignment away from TSM. - $TSM plans a 30x expansion of its Photonic Integrated Circuit (PIC) capacity by 2028, growing from 500 to 25,000 wafers per month - Hanmi Semiconductor is entering the CoWoS packaging equipment market - $NVDA and NTT hosting a conference July 24th to discuss CPO strategies. - 5x general NAND flash price hike this year, market size $489B by next year triggered by RAG/inference. Samsung and SK Hynix make emergency fab investments, NAND equipment suppliers go brrrr. - Gas turbine bottleneck, 40% supply gap accompanied by staggering 5-year delivery cycles (mega-fabs need them for mass production). - AI probe card assembly has hit a severe bottleneck apparently. Which is attempted to by solved with things like Innovation Service's machines. - Nanya, 79.5% gross margins reported, memory go brr. 4x capex for capacity/advanced packaging. - CXMT's STAR Market IPO on July 16, so should bring a lot of attention to memory players in that supply chain. - KYEC $1.4B investment into US for $TSM Arizona output test facilities. Lot of these players like $AMKR and others should go brr in 2028. - $INTC CEO warned last month that helium could hinder the manufacturing costs and delivery times of AI chips - 3D NAND word lines are shifting from Tungsten to Molybdenum starting at the 375-layer node - SambaNova secured JPM for AI inference and raised $1B at an $11B valuation. - HBM prices projections to double in 2027 as $NVDA Rubin platform drives demand. - $MU provides $500 million in funding to support GlobalWafers' US manufacturing capacity - $META 'Iris' will enter mass production in September via $AVGO and TSMC and Meta aims to double computing power to 14GW by 2027. - Largan Precision has secured its first CPO FAU order, mass production slated for middle of next year (kinda indication around Foci and others). - Samsung and SK Hynix have delayed the implementation of hybrid bonding packaging technology for HBM4 apparently - Memory costs (DRAM/NAND) have reached 60% of the BOM for sub-$400 smartphones, causing a severe volume contraction. - SK Hynix successfully rasied $26.5 billion through a Nasdaq ADR - $TSLA issued procurement guidelines requiring suppliers to reach weekly production of 1,000 units by September and double to 2,000-2,500 by year end for its 3rd gen Optimus robot. Apparently Alliance Technology and A-Link may be in this supply chain harmonic reducers and vision lenses? Kinda go through all this stuff every day, but don't wanna be a news reporter so just consolidated stuff I found interesting.

# Neo4j Features and Practical Usage ⚡ "Even in a graph DB, index design is 80% of performance." Put the right index on your MATCH anchor property and lookups go from O(n) to O(log n). 🏷️ Title: Range / Text / Point / Composite index 🔗 URL: 📘 Overview An index is a copy of nodes, relationships, or properties that provides a fast access path to the primary data. Once created, the DBMS keeps it updated automatically. It speeds up the anchor (starting point) of a MATCH, and the Cypher planner selects it automatically based on the predicate. ⚙️ How It Works ・Range (default): solves the most predicates—equality, range comparisons, `IN`, and `STARTS WITH`. This is the first index to reach for. ・Text: `STRING`-only, optimized for `CONTAINS` and `ENDS WITH`—ideal for substring search screens. ・Point: for spatial `POINT` values, optimized for distance queries and bounding-box searches. ・Composite: indexes several properties together, solving multi-condition filters in one go. ・Token lookup: a foundational index that speeds up label / relationship-type lookups. ・Beyond these, full-text indexes and vector indexes (similarity search / GenAI) are also available. 🛠️ Practical Usage Creating range / composite / text / point indexes on anchor properties: ```cypher CREATE INDEX user_email IF NOT EXISTS FOR (u:User) ON ( CREATE INDEX order_composite IF NOT EXISTS FOR (o:Order) ON (o.customerId, o.status); CREATE TEXT INDEX product_name_text IF NOT EXISTS FOR (p:Product) ON ( CREATE POINT INDEX store_loc IF NOT EXISTS FOR (s:Store) ON (s.location); ``` Inspect and drop them: ```cypher SHOW INDEXES; DROP INDEX user_email IF EXISTS; ``` 💡 Use Cases ・Apps that anchor MATCH on ` `Order.orderId`, or `Product.sku`, making lookups O(log n). ・Search screens that pick range for `STARTS WITH`, text for `CONTAINS`/`ENDS WITH`, and point for geo queries. ⚠️ Caveats ・Which index applies depends on the predicate. `CONTAINS` is not served by a range index—it needs a text index. ・Indexes add write cost and storage. Confirm they are actually used with `PROFILE` before relying on them. ・Composite indexes apply from the leading property onward, so column order affects performance. #Neo4j# #Cypher#