Comparison of relational database management systems: Difference between revisions

Revision as of 13:37, 17 December 2024

Revision as of 14:06, 17 December 2024

Line 2,503:

! [[Full text search|Full-text]]

! [[Spatial index|Spatial]]

! [[Forest of Trees|FOT]] Index

! Duplicate index prevention

|-

Line 2,732:

| {{yes}}

| {{yes}}<ref>{{Citation

| url = https://www.ibm.com/docs/en/informix-servers/14.10?topic=considerations-improve-query-performance-forest-trees-index

| publisher = IBM

| url = https://www.ibm.com/docs/en/informix-servers/1415.100.0?topic=considerations-improve-query-performanceindexes-forest-trees-index

| title = Forest of Trees Index

| seriestitle = Informix Infocenter15.0.0 online documentation

| date = 2019 JulyNovember 20222024

| series = Informix 15.0.0 online documentation

}}</ref>

| {{yes}}

Line 3,249:

! [[Full text search|Full-text]]

! [[Spatial index|Spatial]]

! [[Forest of Trees|FOT]] Index

! Duplicate index prevention

|}

Line 3,295:

* <cite id="idx_10">[[#idx 10 back|Note (10):]]</cite> B+ tree and full-text only for now.

* <cite id="idx_11">[[#idx 11 back|Note (11):]]</cite> R-Tree indexing available in base edition with Locator but some functionality requires Personal Edition or Enterprise Edition with Spatial option.

* <cite id="idx_12">[[#idx 12 back|Note (12):]]</cite> FOT or Forest of Trees indexes is a type of B-tree index consisting of multiple B-trees which reduces contention in multi-user environments.<ref>{{Citation

| publisher = IBM

| chapter-url https://www.ibm.com/docs/en/informix-servers/15.0.0?topic=indexes-forest-trees =

| title = Informix 15.0 online documentation

| title chapter = Forest of Trees Index

| series = Development documentation

}}</ref>

==Database capabilities==