Matches in DBpedia 2015-10 for { <http://dbpedia.org/resource/Expression_index> ?p ?o }
Showing triples 1 to 37 of
37
with 100 triples per page.
- Expression_index abstract "An expression index, also known as a function based index, is a database index that is built on a generic expression, rather than one or more 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, an index can be created on the lower-case representation of the user name:CREATE INDEX users__last_name_lower ON users( lower( last_name ) );That will create a unique index on "lower(last_name)". Any queries that search on "lower(last_name)" could then make use of that index:SELECT user_id FROM users WHERE lower( last_name ) = lower( 'Smith' );".
- Expression_index wikiPageID "9020057".
- Expression_index wikiPageLength "1958".
- Expression_index wikiPageOutDegree "8".
- Expression_index wikiPageRevisionID "678075584".
- Expression_index wikiPageWikiLink Case_sensitivity.
- Expression_index wikiPageWikiLink Category:Database_management_systems.
- Expression_index wikiPageWikiLink Column_(database).
- Expression_index wikiPageWikiLink Database_index.
- Expression_index wikiPageWikiLink IBM_DB2.
- Expression_index wikiPageWikiLink Index_(database).
- Expression_index wikiPageWikiLink Oracle_Database.
- Expression_index wikiPageWikiLink PostgreSQL.
- Expression_index wikiPageWikiLink Relational_database_management_system.
- Expression_index wikiPageWikiLinkText "Expression index".
- Expression_index wikiPageWikiLinkText "Expression".
- Expression_index wikiPageWikiLinkText "expression index".
- Expression_index hasPhotoCollection Expression_index.
- Expression_index wikiPageUsesTemplate Template:Multiple_issues.
- Expression_index wikiPageUsesTemplate Template:Reflist.
- Expression_index wikiPageUsesTemplate Template:See_also.
- Expression_index subject Category:Database_management_systems.
- Expression_index hypernym Index.
- Expression_index type Article.
- Expression_index type Work.
- Expression_index type Article.
- Expression_index type Page.
- Expression_index type Thing.
- Expression_index comment "An expression index, also known as a function based index, is a database index that is built on a generic expression, rather than one or more 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 seeAlso Comparison_of_relational_database_management_systems.
- Expression_index sameAs 式インデックス.
- Expression_index sameAs m.027tqs1.
- Expression_index sameAs Q5421708.
- Expression_index sameAs Q5421708.
- Expression_index wasDerivedFrom Expression_index?oldid=678075584.
- Expression_index isPrimaryTopicOf Expression_index.