Matches in DBpedia 2014 for { <http://dbpedia.org/resource/Expression_index> ?p ?o }
Showing triples 1 to 27 of
27
with 100 triples per page.
- Expression_index abstract "An expression index is a database index that is built on a generic expression, rather than on a list of columns. This allows indexes to be defined for common query conditions that depend on data in a table, but are not actually stored in that table.A common use for an expression index is to support case-insensitive searching or constraints. For example, if a web site wants to make user names case-insensitive, but still preserve the case as originally entered by the user, a unique index can be created on the upper- or lower-case representation of the user name:CREATE UNIQUE INDEX site_user__user_name_lower ON site_user( lower( user_name ) );That will create a unique index on "lower(user_name)". Any queries that search on "lower(user_name)" could then make use of that index:SELECT user_id FROM site_user WHERE lower(user_name) = lower('Decibel');".
- Expression_index wikiPageID "9020057".
- Expression_index wikiPageRevisionID "580598515".
- Expression_index context "October 2009".
- Expression_index hasPhotoCollection Expression_index.
- Expression_index unreferenced "January 2007".
- Expression_index subject Category:Database_management_systems.
- Expression_index subject Category:PostgreSQL.
- Expression_index type Abstraction100002137.
- Expression_index type Code106355894.
- Expression_index type CodingSystem106353757.
- Expression_index type Communication100033020.
- Expression_index type DatabaseManagementSystem106588785.
- Expression_index type DatabaseManagementSystems.
- Expression_index type Software106566077.
- Expression_index type Writing106359877.
- Expression_index type WrittenCommunication106349220.
- Expression_index comment "An expression index is a database index that is built on a generic expression, rather than on a list of columns. This allows indexes to be defined for common query conditions that depend on data in a table, but are not actually stored in that table.A common use for an expression index is to support case-insensitive searching or constraints.".
- Expression_index label "Expression index".
- Expression_index label "式インデックス".
- Expression_index sameAs 式インデックス.
- Expression_index sameAs m.027tqs1.
- Expression_index sameAs Q5421708.
- Expression_index sameAs Q5421708.
- Expression_index sameAs Expression_index.
- Expression_index wasDerivedFrom Expression_index?oldid=580598515.
- Expression_index isPrimaryTopicOf Expression_index.