Skip to content

H
h2database
切换分支/标签
历史 查找文件
  • Steve McLeod's avatar
    Add index hints (#425) · b2ef093c
    由 Steve McLeod 提交于 
    * Added parsing of table hints

* Implemented USE INDEX hints

* Added docs, tidied up code for submission

* Added docs, tidied up code for submission

* Removed used of final static field that would cause problems with Tomcat class unloading

* Removed used of final static field that would cause problems with Tomcat class unloading

* A table with no index hints now has indexHints == null, instead of an employ instance of IndexHints. For the common case of no index hints, this will prevent some unnecessary object creation.

* Index Hints now is backward compatible with using the "USE" as a table alias

* Added TestIndexHints to list of all tests

* Added index hints to text generated by TableFilter.getPlanSQL();

* Improved field names (a field called indexList was actually a set);
Added test for ensuring getPlanSQL lists index hints in correct order

* Improved unit test for making sure getPlanSQL renders index hints list in correct order
    b2ef093c
名称
最后提交
 最后更新
h2 Add index hints (#425)
.gitignore add temp folder to .gitignore
.travis.yml Cache Maven Local Repository
README.md Added TravisCI build status image.
README.md

Welcome to H2, the Java SQL database. Build Status

The main features of H2 are:

  1. Very fast, open source, JDBC API
  2. Embedded and server modes; in-memory databases
  3. Browser based Console application
  4. Small footprint: around 1.5 MB jar file size

More information: http://h2database.com

Features

H2 Derby HSQLDB MySQL PostgreSQL
Pure Java Yes Yes Yes No No
Memory Mode Yes Yes Yes No No
Encrypted Database Yes Yes Yes No No
ODBC Driver Yes No No Yes Yes
Fulltext Search Yes No No Yes Yes
Multi Version Concurrency Yes No Yes Yes Yes
Footprint (jar/dll size) bug MB duplicate MB bug MB good first issue MB invalid MB