extension index

[/ɪkˈstɛnʃən ˈɪndɛks/]
nounpl: extension indexes / extension indices
índice de extensão
1. A database index created on one or more columns that extends beyond the primary key to improve query performance for specific search patterns
The extension index on the email column allows faster lookups of user accounts by email address.
O índice de extensão na coluna de email permite buscas mais rápidas de contas de usuário por endereço de email.
2. In medical/anatomical contexts, a measurement or scale indicating the degree of extension or stretching of a joint or body part
The extension index of the patient's knee showed significant improvement after physical therapy.
O índice de extensão do joelho do paciente mostrou melhora significativa após a fisioterapia.
3. A supplementary index that provides extended or additional indexing functionality beyond standard indexing methods
Using an extension index helped reduce query execution time from 5 seconds to 500 milliseconds.
Usar um índice de extensão ajudou a reduzir o tempo de execução da consulta de 5 segundos para 500 milissegundos.
This term is primarily used in technical (database management systems) and medical/physiotherapy contexts. In Brazil, it's commonly found in IT documentation and healthcare settings. The term is universal across English-speaking and Portuguese-speaking technical communities, with minimal regional variation in usage.
Synonyms / Sinônimos
secondary indexcomposite indexmulti-column indexsupplementary index
Antonyms / Antônimos
primary keyclustered index

Regional Variations

General Brazilian
índice de extensão
Standard term used in Brazilian technical and medical contexts
São Paulo
índice de extensão
Commonly used in tech and healthcare sectors in São Paulo
Rio de Janeiro
índice de extensão
Standard usage in medical and database contexts
Portugal
índice de extensão
Equivalent Portuguese term, used in same technical and medical contexts

Related Words

database indexquery optimizationindexing strategyperformance tuningrange querycovering index

Related Idioms & Phrases

create an extension index
drop an extension index
utilize an extension index for performance
Look up more words on Fala2Me
The free English-Portuguese dictionary with real Brazilian accents, NYC slang, conjugator and more
Open Fala2Me →