One of the limitations of the SQLite SQL engine is that it cannot use indexes for LIKE comparisons.

SQLite SQL引擎的一个缺陷是无法将索引用于LIKE比较。

youdao

When the engine is initialized, this file is read and all SQL statements are processed, thus recreating the entire database.

初始化引擎之后，该文件被读取，然后其中所有的 SQL 语句都被运行，从而完成整个数据库的重建。

youdao

The access plan is created by the database engine based on the SQL statement that is submitted.

访问计划是由数据库引擎根据提交的sql语句创建的。

youdao

The Splice SQL Engine also scales to handle business intelligence and analysis, and works turnkey with tools like MicroStrategy and Tableau.

FORBES: Former NASA Researcher (And Billionaire) Jumps Back In The Startup Game

While the Apache Hive project is a noble effort, it takes years and deep engineering expertise to create a fully compliant, scalable, optimized SQL query engine.

FORBES: Why SQL Matters, the Limits of Open Source, and Other Lessons of EMC Greenplum's Pivotal HD

He helped build the database engine in SQL Server 2000, co-founded Spathe.com, and served as Director of Technology at Progress Software and as chief technology officer at AppZero.com.

FORBES: Min.us Makes File Sharing A Snap