Subject Re: [ib-support] Is a joined query faster than a subquery, or doesn't it matter?
Author Ann W. Harrison
At 09:03 AM 2/15/2001 +0100, Jörg Schiemann wrote:

>There is only one thing which is confusing me, maybe because of my lack in
>the english language. Indexes and indices, is it the same or is there a

The word "index" comes from Latin (4th? 5th? declension neuter.) In Latin
the nominative plural would be indice (without the s, I think. It's been a
LONG time.) When we were setting out the system tables, I thought indices
sounded more educated. In fact, it sounds pedantic and also incorrect.

Careful English usage separates two senses of the word index. One is a
measure of something - the Consumer Price Index for example. When plural,
those are correctly called indices. The other is a table of keys into
a lump of data (book index, database index) and its plural is indexes.


We have answers.