OceanBase replaces vector similarity with an ontology graph of business objects, relationships, attributes, and metrics, enabling DataAgents to accurately retrieve all relevant KPIs and trace root causes through autonomous graph exploration in banking analytics.
OceanBase builds an ontology-driven semantic layer that maps business objects, relationships, and calculation rules into a knowledge graph, allowing DataAgent to traverse the graph for complete metric retrieval and root-cause analysis, starting from a single domain and iteratively refining through user feedback.
This article compares five major Chinese domestic databases across three technical generations—traditional centralized (Dameng, Kingbase), open-source modified (openGauss), and self-developed distributed (OceanBase, TiDB)—detailing their kernel origins, compatibility targets, strengths, weaknesses, and a decision framework based on compliance requirements, existing workload, scale, and operational readiness.
The article argues that manual database sharding is shifting from a default scaling strategy to a fallback option, as native distributed databases like TiDB and OceanBase internalize sharding, routing, and distributed transactions, reducing application complexity, though they introduce higher latency, operational overhead, and cost, making single-node MySQL with proper indexing preferable for smaller datasets.
The article analyzes OceanBase’s newly released lake‑house AI database, focusing on its multimodal table feature that unifies storage, transaction, governance and hybrid search for images, PDFs, vectors and other non‑structured data, addressing the data‑consistency and latency challenges of Agent‑driven applications.
AI DatabaseColumn Group ConsistencyData Governance
The article explains how OceanBase tackles AI‑agent challenges such as isolation, memory, and trial‑and‑error by introducing logical tenants, layered decoupling, hybrid search, database branching, multimodal large‑object storage, and Model‑in‑DB AI columns, backed by benchmark results and real‑world deployments.
DeWu, a leading fashion e‑commerce platform, evaluated and adopted OceanBase as a multi‑model database to replace a heterogeneous stack of MySQL, TiDB, MongoDB, HBase, ClickHouse, and others, achieving up to 200× query speedups, 40%+ storage savings, high‑availability with RPO = 0, and a streamlined operations model while documenting migration challenges and future roadmap.
The article analyzes how OceanBase’s new AI‑native database tackles the data‑layer challenges of autonomous agents by introducing logical tables, multi‑modal storage, Fork DB sandboxes and lake‑warehouse integration, arguing that the product’s value lies beyond simple vector retrieval.
Lakebase, the core engine of OceanBase AI Database, unifies storage, management, computation and search for structured, unstructured and vector data, offering multimodal data capabilities, flexible deployment modes, and AI‑oriented use cases such as autonomous driving and financial document analytics.
The article analyzes the write bottleneck of processing 30,000 payment orders per second on an Oracle‑Java‑Spring stack, explains why sharding was used historically, why MQ‑based peak‑shaving is discouraged, and compares self‑built sharding with modern distributed databases such as PolarDB‑X, TiDB and OceanBase, while summarizing public practices from major Chinese tech firms.
Alibaba’s same‑city active‑active architecture deploys multiple data centers within one city, splits traffic between them, and ensures instant failover with layered high‑availability across access, application, and data layers, using technologies like DNS, SLB, Nginx, Redis and OceanBase.
The article reviews the rise and decline of traditional database sharding, explains its technical pitfalls such as wrong shard keys, cross‑database joins, and distributed transactions, compares it with emerging NewSQL solutions like TiDB, OceanBase and PolarDB‑X, and offers practical criteria for choosing the right architecture.
The article systematically compares TiDB, OceanBase, and PolarDB across architecture, consistency mechanisms, scalability, high‑availability, and operational characteristics, highlighting each system’s strengths, limitations, and the business scenarios they best serve, and offers a practical decision‑making framework for selecting the right distributed database.
This article explains why vector databases are essential for AI-driven unstructured data, surveys the current landscape of professional and extended vector databases, and provides a detailed technical comparison between Milvus and OceanBase, covering architecture, features, performance, and product positioning.
In multi‑node OCP deployments, accessing monitoring data via the master node IP/VIP can trigger a 401 "invalid VIP" error, and this guide explains the root cause, how OCP validates source IPs, and provides two reliable methods to correct the source IP configuration.
A production migration from Oracle to OceanBase caused a column‑length change to trigger offline DDL, leading to connection errors, INSERT latency spikes, and complete table blockage; the article reproduces the fault, analyzes the OMS conversion and OceanBase DDL rules, and provides a two‑step remediation and a method to verify online DDL execution.
The author describes using an AI code‑assistant to quickly create a web page that lists all released OceanBase versions, extracts their default parameter files from the source code, and highlights differences between selected versions, all without writing any manual code and deploying it on GitHub Pages.
This article walks through the challenges of using goInception with OceanBase‑MySQL tenants, details the code modifications required to parse OB's Query Plan, shows how to expose the enhanced engine via a Python wrapper, and presents validation results demonstrating accurate, low‑latency SQL auditing.
This article walks through a real‑world OceanBase cluster outage, detailing the environment, emergency restart steps, log‑driven fault analysis of disk I/O failures and Linux OOM‑killer activation, and presents concrete mitigation measures to prevent similar incidents.
During an Oracle‑to‑OceanBase migration, a client encountered extremely slow INSERT…SELECT batch jobs due to a global unique non‑partitioned index, and the article walks through extracting logical and physical plans, pinpointing the bottleneck operators, and demonstrates converting the index to a partitioned one to cut execution time from over 30 minutes to 14 minutes.
This guide explains why OBD 3.6.0 mistakenly removes the primary tenant when deleting a standby tenant, demonstrates the issue with step‑by‑step commands and outputs, and provides a reliable procedure—decoupling, dropping, or failover—to safely delete or promote standby tenants.
This guide explains the background, terminology, pre‑conditions, detailed step‑by‑step procedures, and rollback plan for executing reverse incremental migration from MySQL to OceanBase, covering trigger and foreign‑key handling, OMS operations, data validation, and how to safely switch traffic back to MySQL.
A customer observed a SQL statement that runs twice as fast on Oracle as on OceanBase, prompting a detailed analysis of execution plans, leader distribution, and distributed query behavior, followed by practical hint and table‑group optimizations that reduce the runtime from several seconds to sub‑second levels.
This article explains why a tenant in OceanBase may experience frequent mini compactions, shows how to locate the responsible DML statements by querying merge info and tablet IDs, demonstrates the process with test tables, and provides conclusions and references for further investigation.
The OceanBase team’s LCL+ algorithm, a lock‑chain‑length based distributed deadlock detection and elimination method, eliminates the need for a global wait‑for graph, achieves single‑victim unlocks, and dramatically improves throughput while reducing tail latency in production database clusters.
A production OceanBase Oracle‑mode database experienced excessive Incr‑Sync delay due to a DDL timeout, and the article walks through log analysis, the oracleSocketTimeout parameter issue, configuration changes, verification steps, and final recommendations to resolve the blockage.
This article details OceanBase's evolution from a distributed OLTP system to a unified HTAP database, covering its cost‑based optimizer, vectorized execution, integrated row‑column storage, bypass import, materialized views, external tables, full‑text search, and real‑world use cases for real‑time analytics.
Action OMS, a customized version of OceanBase’s OMS tool, enables seamless migration and real‑time data subscription from Microsoft SQL Server (2008‑2019 Enterprise) to OceanBase, detailing preparation, configuration, CDC setup, and best‑practice considerations for reliable, low‑latency data transfer.
This article explains why the binlog Position may not advance after executing SQL on an OceanBase MySQL tenant, outlines two main causes, and provides step‑by‑step commands to verify binlog task health and identify unsupported statements.
This article walks through practical techniques for optimizing slow queries in OceanBase, covering essential data collection, distinguishing trace_id, sql_id, and plan_id, handling multiple sql_id scenarios, and manually gathering statistics across versions, with detailed SQL examples, tables, and visual aids.
This article walks through a real‑world OceanBase ODP binlog connection failure, explains the error message, analyzes possible causes, shows how to trace logs and configuration, and provides a concrete fix by correcting the binlog_service_ip setting and restarting ODP.
This article explores why many enterprise AI projects fail to deliver value, analyzes the complexity of real‑world AI use cases, and presents a step‑by‑step demo that combines vector, keyword, numeric, and spatial queries using OceanBase as a unified multimodal data store.
This article explains OceanBase's Offline DDL implementation, showing how it rebuilds tables, manages table locks, tracks execution progress, evaluates performance, and answers common questions about lock behavior and time estimation with detailed SQL examples and log analysis.
This article analyzes why an OceanBase JDBC driver fails with "Access denied" errors when deployed in Kubernetes, compares it with the MySQL driver, explains the role of IP whitelist verification, and provides step‑by‑step troubleshooting, configuration adjustments, and preventive measures.
This guide walks through diagnosing OceanBase tenant memory exhaustion by tracing error codes, extracting TRACE_IDs, analyzing OBServer logs, querying virtual tables for memory allocation details, and applying a version upgrade to resolve the underlying memory leak.
This article explains why using variable assignment expressions inside ORDER BY clauses can trigger severe OCP alarms, analyzes the underlying source code in OceanBase, demonstrates unpredictable query results with examples, and offers safer alternative patterns.
This article explains why OceanBase enforces minimum values for min_worker_cnt and max_worker_cnt, shows the source‑code formulas used to compute them, demonstrates how to verify and adjust these parameters, and clarifies the impact of tenant memory and Meta‑tenant reservations on the final values.
This article details HuoLala's journey from confronting large‑model knowledge gaps and latency issues to adopting Retrieval‑Augmented Generation (RAG) with vector databases, outlining their architecture challenges, selection criteria, deployment scenarios, and future plans for AI‑driven logistics.
This article analyzes a slow SQL query by examining driver tables, execution plans, and table row counts, then demonstrates three optimization approaches—setting a small table as driver, setting a large table as driver, and switching to hash joins—showing their impact on execution time and providing practical guidelines for selecting the best strategy.
This article explores OceanBase v4 CPU‑related parameters such as workers_per_cpu_quota, cpu_quota_concurrency, and parallel_servers_target, explains their formulas, demonstrates experimental setups and results on tenant thread limits, large‑query impact, and provides practical tuning recommendations based on observed performance data.
Zhihu’s evolving data architecture transitioned from a single MySQL setup to a heterogeneous ecosystem of SQL, NoSQL, and graph databases, ultimately adopting OceanBase for its multi‑tenant, high‑compression capabilities, supported by tools like OMS, OCP, and ob‑operator to achieve cost savings, performance gains, and robust operations.
This article investigates a slow OceanBase SQL query by examining CPU and TopSQL metrics, dissecting the execution plan, identifying batch join inefficiencies, rewriting the SQL for better performance, and demonstrating a reduction in execution time from over 2600 seconds to under one second.
This paper presents the design, implementation, and experimental evaluation of OceanBase's unitization architecture for large‑scale online map services, demonstrating superior disaster‑recovery, high‑throughput OLTP/OLAP performance, and storage efficiency compared with competing distributed databases.
At ICDE 2025 in Hong Kong, OceanBase showcased six accepted papers—including a Best Industry and Application Paper Runner‑Up award—while also hosting a technical symposium on AI‑era databases and presenting detailed abstracts on distributed database innovations, secure query processing, federated learning, hypergraph clustering, query equivalence, and cardinality‑estimation workload generation.
This guide walks developers through downloading, installing, and using OceanBase Desktop on macOS, covering dependency setup with OrbStack, GUI features, cluster startup, tenant management, and how the tool simplifies local OceanBase cluster deployment.
This article analyzes a puzzling case where data consistency checks between a MySQL source and an OceanBase target report matching results despite visible record differences, explains the OMS ordinary and Inmode validation modes, and outlines scenarios that trigger Inmode verification.
This article details a systematic performance test of OceanBase's online DDL capabilities, measuring TPS and QPS impacts across various DDL operations, describing the test environment, scripts, results, and conclusions for reliable database schema changes.
This article explains the differences between manual statistics collection methods in OceanBase 3.x and 4.x, compares DBMS_STATS and ANALYZE commands across MySQL and Oracle modes, provides version‑specific tables, detailed code examples for table, partition, and schema level collection, and shows how to verify statistics.
This article presents a step‑by‑step migration plan for moving a PolarDB PostgreSQL 11.9 tenant to an OceanBase 4.2.1.10 Oracle‑compatible tenant, covering background, scope, task distribution, user and permission conversion, table‑structure transformation, DataX data transfer, performance tuning, error handling, monitoring, and final recommendations.
This article explains OceanBase's full‑link tracing feature, covering its definition, internal working principle, trace‑log structure, span and tag details, configuration steps, and how to view trace data via the show‑trace command or the OCP visual interface, helping DBAs quickly diagnose performance issues.
This article explains why altering a column length in OceanBase may trigger an "Alter charset or collation type not supported" error, analyzes the underlying charset and collation settings, and provides a solution that explicitly specifies charset and collation to ensure successful column expansion across versions.
This article examines a failure case of OceanBase's OBLogProxy service in Binlog mode, detailing background conditions, status checks, log analysis, the root cause of timestamp mismatches, and provides step‑by‑step remediation procedures to restore normal binlog processing.
This case study demonstrates how the AI assistant ChatDBA identifies and resolves a tenant data‑synchronization failure in an OceanBase primary‑backup cluster, detailing four interactive troubleshooting rounds, the final SQL fix, and a comparative analysis with the DeepSeek‑R1 model.
This article details a step‑by‑step investigation of daily OceanBase no‑leader alerts caused by network bandwidth saturation, covering log analysis, clock synchronization issues, RPC backlog, and provides practical solutions such as bandwidth expansion and backup throttling to restore cluster stability.
This article details the background, configuration, and step‑by‑step troubleshooting process for a data pipeline that replaces a MySQL source with OceanBase using OBLogProxy in binlog mode, explains why downstream reads missed incremental data, and provides conclusions and optimization measures.
This article explains the background of tenant creation failures caused by insufficient CPU resources in OceanBase, details the calculation of usable CPU in version 4.x, shows how to query CPU usage with SQL, describes related configuration parameters, and provides step‑by‑step procedures for modifying cpu_count and testing over‑commit scenarios across different OceanBase versions.
This article details a step‑by‑step investigation of OceanBase single‑node replica expansion failures, highlighting missing sys‑tenant expansion, deprecated table replica commands, log_disk_size misconfiguration, log‑stream mechanics, and provides concrete SQL and ALTER statements to reproduce and resolve the issue.
This article details a timeout incident in an OceanBase cluster during a merge operation, explains the emergency suspension and resumption steps, analyzes log and metric data to identify queue backlog and disk I/O saturation as root causes, and offers practical optimization recommendations.
This article analyzes why OceanBase backup clean tasks become stuck, examines log and query evidence of scheduler failures and NFS I/O errors, and recommends correcting NFS configuration to resolve the backup cleanup problem.
This article explains why JDBC access to OceanBase (Oracle mode) LOB columns can trigger an ORA-06502 "no data found" error, analyzes the driver’s readFromServer implementation, and shows how disabling the useLobLocatorV2 option eliminates the exception.
A cross‑border e‑commerce company replaced its massive MySQL instance with OceanBase, detailing the business drivers, selection criteria, two‑phase migration process, performance gains, cost savings, remaining incompatibilities, and practical operational lessons learned.
The article details how WanJia Shuke, the tech arm of China Resources Vanguard, tackled retail system fragmentation, user‑experience degradation, complex linkages and scalability limits by migrating dozens of projects to the distributed OceanBase database, achieving up to 70% performance improvement, 25% cost reduction and streamlined operations.
This article details the background, challenges, and technical solutions behind the partitioning redesign of the KPOS reporting system on OceanBase, covering deployment choices, parameter tuning, data migration, phased rollout, performance gains, encountered issues, and future scaling plans.
The article recaps Zhihu's Cloud Native Innovation Forum where experts from AutoMQ, OceanBase, and Flashcat shared practical solutions on streaming data ingestion, unified database architectures, and AI‑driven observability, highlighting real‑world deployments, performance optimizations, and cost‑saving strategies.
This article presents a systematic seven‑step troubleshooting procedure for the common "Access denied" login error when connecting to an OceanBase cluster, covering password verification, network connectivity, user privileges, client compatibility, tenant parameters, obproxy logs, and configuration checks.
This article explains the differences between OceanBase V3 and V4 statistics storage, clarifies the optimal way to query V3 statistics for sys, MySQL, and Oracle tenants, and outlines the unified approach and recommended DBMS_STATS usage in V4.
This article explains how to accurately calculate the real data size in OceanBase by using OCP cluster overview, system views, and SQL queries for server‑level, tenant‑level, and table‑level statistics, covering differences between V3 and V4 versions and the use of obdiag.
This article presents a step‑by‑step AI‑assisted investigation of an OceanBase performance test that triggered error 4013 due to memory limits, detailing four interactive rounds with ChatDBA, the root‑cause analysis, and practical remediation measures.
An OceanBase 4.2.1.4 deployment experienced random selection of data sources when adding tenant replicas, causing cross‑city bandwidth congestion; the article reproduces the issue, analyzes its cause, and presents three remediation methods—including setting the choose_migration_source_policy parameter, manual replica addition, and temporary network isolation.
OceanBase’s open‑source ecosystem—spanning data migration tools, developer utilities, a database proxy, and robust operational management—delivers comprehensive, open, and compatible support that enhances development, migration, and maintenance, positioning it as a competitive enterprise‑grade distributed relational database.
vivo migrated five 20‑TB MySQL clusters to OceanBase using OCP, oblogproxy, and OMS, eliminating sharding costs, achieving over 70% storage savings, improving consistency and performance, and leveraging native distributed architecture, tenant isolation, and strong compression to support scalable, reliable operations.
Data CompressionDatabase MigrationDistributed Database
This article demonstrates how to use ActionOMS to capture incremental changes from OceanBase, stream them to Kafka in various formats, and employ Flink to deduplicate and aggregate transaction data into a daily summary, illustrating a complete real-time data pipeline for financial use cases.
This guide details the upgrade procedures, prerequisites, and impact considerations for OceanBase, OBproxy, OCP, and OB‑DashBoard across Kubernetes and bare‑metal environments, providing step‑by‑step commands, dashboard actions, and DBA precautions to ensure a smooth transition.
This article walks through a real‑world OceanBase NTP clock desynchronization problem, demonstrating how the ChatDBA AI assistant guides four rounds of interactive troubleshooting, identifies misconfigured ntpdate‑wrapper scripts, and provides a concrete solution to restore proper time sync.
This guide walks you through upgrading the ob‑operator, creating S3 credentials, configuring an OBTenantBackupPolicy YAML, applying the backup, and verifying the backup status to achieve a full data backup of an OceanBase 4.2.5 tenant to Baidu Cloud BOS using Kubernetes.
This guide walks you through deploying OceanBase OBProxy and the OceanBase Dashboard on a Kubernetes cluster using yaml manifests, a setup script, and Helm, covering environment requirements, configuration details, verification steps, and access instructions.
This article explains how to replace Oracle's XMLAGG with OceanBase's WM_CONCAT, analyzes why the result order is lost in OceanBase 3.x, demonstrates reproduction steps, shows that adding a NO_REWRITE hint restores ordering, and provides the final SQL solution and notes for OceanBase 4.x.
This guide walks you through installing the OB‑Operator, preparing Kubernetes prerequisites, deploying the operator and an OceanBase cluster, and verifying the deployment, providing practical commands and configuration examples for a production‑ready setup.
This article explains how to locate OBServer crash logs, extract stack traces from observer.log, map memory addresses to source code using addr2line and gdb, identify the faulty function ObMPStmtExecute::copy_or_convert_str, and verify the issue through the OceanBase knowledge base, providing a systematic five‑step approach for rapid crash diagnosis.
This article details a step‑by‑step investigation of a compaction‑stuck problem in OceanBase, covering background, environment setup, view and log analysis, root‑cause identification related to clock drift, and the corrective actions taken to restore normal merging.
This article explains how to troubleshoot a slow OceanBase stored procedure by locating its trace_id, analyzing audit logs to identify non‑cached UPDATE statements, revealing that preceding TRUNCATE operations invalidate the plan cache, and finally recommending replacing TRUNCATE with DELETE to restore performance.
This guide walks through setting up a CentOS virtual machine, configuring a Python 3.8 environment with Miniconda, forking and cloning the OceanBase obdiag repository, using VSCode remote‑SSH for development, and leveraging the Tongyi Lingma AI plugin to generate unit tests and documentation, culminating in a contribution workflow.
This article walks through a production‑level OceanBase connection‑timeout incident, detailing how to examine OBProxy logs, capture and analyze network packets with tcpdump and Wireshark, identify a blocked random port, and apply kernel‑parameter fixes to prevent the issue.
This article explains why the OBOracle "set transaction read only" command provides repeatable‑read semantics, evaluates the behavior of the JDBC conn.setReadOnly(true) setting, and shows how to achieve true repeatable‑read isolation by enabling the oracleChangeReadOnlyToRepeatableRead option in the OceanBase client.
The article introduces ActionOMS, a customized version of OceanBase Migration Service that adds automated performance and fault diagnosis, explains its architecture, showcases a real‑world case of Oracle‑to‑OceanBase synchronization, and demonstrates how the tool improves migration throughput and reduces latency.
This article analyzes why creating a resource pool with 4C12G fails in an OceanBase single‑node cluster despite sufficient CPU and memory, explains the relationship between LOG_DISK size and tenant memory, provides calculation formulas, verification steps, and practical recommendations to avoid LOG_DISK resource shortages.
This article explains how the ActionDB team extended OceanBase by designing, registering, and implementing the ST_PointN function to extract the N‑th point from geometry objects, covering registration metadata, code integration, algorithm details, and the advantages of a custom GIS function for enterprise databases.
This article explains what NewSQL databases are, outlines their core characteristics, reviews major products such as Spanner, CockroachDB, TiDB, OceanBase and TDSQL, and discusses typical use cases ranging from financial services to HTAP workloads.
This article examines why a scalar subquery in an OceanBase 3.2.3.3 SQL statement takes over 1000 seconds, breaks down the execution plan, identifies the costly nested-loop behavior, and presents a rewrite using WITH and LEFT JOIN that reduces the cost from 788 million to 3.6 million and cuts runtime to about 10 seconds.
This article analyzes why a scalar subquery in an OceanBase 3.2.3.3 SQL statement runs over 1000 seconds, explains the execution plan details, and presents a rewrite using WITH and LEFT JOIN to replace SUBPLAN FILTER, reducing cost from 788 million to 3.6 million and execution time to 10 seconds.
The IDC 2023 China financial industry distributed transactional database market report shows a $2 billion market, with OceanBase capturing 17.1% overall and leading local‑deployment share at 23.2%, while also dominating insurance‑securities (42.5%) and achieving strong adoption across major banks and insurers.
This article explains how to obtain the SQL ID, create an outline bound to that ID, and correctly verify its effect in OceanBase, highlighting common pitfalls such as using the wrong schema or relying on EXPLAIN, and provides practical code examples for each step.
This article presents a detailed experimental study of OceanBase's Arbitration Service in a 2F1A (two full‑function replicas plus one arbitration node) configuration, examining how the system behaves when one or both full‑function replicas fail, how log‑stream degradation and permanent offline mechanisms work, and how normal service is restored after node recovery.
This article provides a comprehensive overview of Hybrid Transactional/Analytical Processing (HTAP) databases, detailing the four architectural patterns, five core technologies, and a comparative analysis of major Chinese HTAP products such as TiDB, OceanBase, PolarDB‑X, TDSQL, GaussDB and GreatSQL, while also discussing their characteristics and remaining challenges.
This article walks through a real‑world OceanBase OMS migration case where adding an OCP association triggers a “Server Internal Error”, detailing log analysis, metadb schema inspection, OAT deployment checks, the impact of the MySQL “-f” flag, a temporary fix, and the root‑cause conclusion.
This article provides a comprehensive guide to installing and configuring OceanBase single-node (centralized) clusters, explains primary‑standby tenant architectures, details performance benchmarking against MySQL using sysbench and fio, and offers recommended resource settings and diagnostic procedures for optimal operation.
This article demonstrates how to diagnose and resolve repeated UPDATE failures in OceanBase by extracting information from Top SQL, log files, and the gv$sql_audit view, identifying error codes such as 6005, 6003, and 6212, and applying corrective actions like adjusting timeout settings, killing lock‑holding sessions, and checking lock statistics.
The OceanBase community offers a detailed, eight‑session DBA tutorial covering the platform’s architecture, deployment, migration, performance tuning, diagnostic tools, and ecosystem components, complemented by live streaming, hands‑on exercises, certification incentives, and real‑world user testimonials to help developers and DBAs master this distributed database.
In his OceanBase developer conference keynote, chief scientist Yang Zhenkun explains how cloud resource pooling enables distributed databases to achieve elastic compute and storage, discusses the evolution of databases, the challenges of transaction processing, and envisions fully shared, on‑demand cloud database services.
This article analyzes a slow NOT IN subquery that OceanBase rewrites into a NESTED‑LOOP ANTI JOIN, explains why HASH ANTI JOIN is not chosen due to NULL‑sensitive semantics and missing NOT NULL constraints, compares the behavior with Oracle's Null‑Aware Anti Join, and provides practical rewrite and hint‑based optimization recommendations.