tags:

views:

798

answers:

11

A table can have 1 index, or it has two or more ind...???

Is it Indexes or Indices? I'm just asking since I've noticed that they're both used quite often. Even the Wikipedia page seems to support both spellings, although it prefers to use Indexes.

Or, just to make it simple... Which spelling is the preferred one?

+1  A: 

I prefer Indices.

Simon P Stevens
+33  A: 

This page makes a clear distinction:

"The plural of the noun index should always be indices. This handily distinguishes it from the present tense of the verb index, which can only be indexes."

-http://federalist.wordpress.com/2006/09/28/grammar-indexes-vs-indices/

Chris Ballance
Well, that makes sense. Indexes if it's a verb, Indices if it's a noun.
Workshop Alex
actually, both are perfectly valid English
geowa4
Which reminds me... Is anyone going to fix all those wikipedia pages where Indexes is used as noun and Indices as verb? ;-)
Workshop Alex
Interesting (and it matches my preference). But for the sake of playing devil's advocate, merriam-webster lists both - http://www.merriam-webster.com/dictionary/index
Simon P Stevens
@WorkshopAlex: Are you volunteering? =:)
Simon P Stevens
I agree with your choice, but your linked source is a blogger who was told which to use by his grammar teacher. :-)
Nosredna
Totally unnecessary to make this distinction: give me an example where you actually be confused. "He indexes his indexes." "The database indexes index..." or "The database indexes" etc. etc. etc. Never a problem in English. If English were phonetic, then it would be really cool...
Yar
The only usage that makes me vomit is when some uses "indice" as a singular.
Nosredna
@WorkshopAlex: Does Wikipedia really use indicies as a verb?
Carson Myers
Thats funny because I don't normally confuse nouns and verbs when speaking/reading.
theycallmemorty
@the "we don't mix up verbs and nouns" croud: There are people in software developemnt who are not native english speakers. Keeping the language simple and the interpretation (mostly) free of context-sensitivity makes it easier for everyone.
Joachim Sauer
+4  A: 

indices

http://www.thefreedictionary.com/index

samoz
A: 

Both are valid. I prefer indexes, as it easily convey the meaning.

aJ
A: 

are we voting or answering :) I vote Indexes b/c that is what I always use.

Cody C
+12  A: 

He indexes into indices.

Nosredna
+4  A: 

Both are valid English; that is why you see both used. One person may be used to the other, while the guy down the hall says it the other way. See dictionary.com if you haven't already.

geowa4
Also in the Oxford Dictionary of English, something like "plural: "indexes" or "indices" (especially in technical writing)".
Richard
But I live by myself.
JoeCool
+1  A: 

Good question.

I generally feel that "indices" is more correct, but "indexes" more common. So when not trying to be extra highbrow, I uses "indexes".

Avi
A: 

One isn't more correct than the other. We speak English, not Latin.

However, if you restrict it to databases, I think the more common spelling is indexes, and Google supports me on this.

Simon Nickerson
Nosredna
Well quite; but array indices and database indexes are different beasts. I would probably use "array indices", but on the other hand, I would also say "Oracle indexes".
Simon Nickerson
Language is not a popularity contest! Or is it?
Yar
"Language," William S. Burroughs reminded us, "is a virus from outer space."
Nosredna
A: 

Just avoid "index" as a noun. Use it as an adjective. "Index Columns" or fields or whatever.

Another solution is to go with the more fun, "indexerizers" or "indexers"... it depends if you want people to take you seriously or not.

"Thing" and "thingers" are generally good, and I prefer them to actually saying what I'm talking about.

Yar
He indexes the indexed indices? :-) Well, it was just something I noticed when some application that I used to generate documentation for my database continuously used "Indexes" instead of "Indices" as noun. Since I'm not a native English-speaking person, it tends to be confusing. Actually, in Dutch, Index has the same meaning but only as noun. The verb is "indexeren" in dutch, thus making a clearer difference. Then again, in dutch, the plural of the index verb is either "indexen" or "indices"... Am really disliking this word now. :-)
Workshop Alex
I think the point in English, or at least my point, is that being correct doesn't matter as much, since the word's placement lets you know whether it is a noun or a verb. But check http://federalist.wordpress.com/2006/09/28/grammar-indexes-vs-indices/ ... basically, if it's good enough for the the conservative WSJ people, you should probably get used to it and use one MWF and the other Tuesday and Thursday.
Yar
A: 

if all the big dictionaries are pandering to ignorance, it explains how English became the ridiculously difficult language it is. Indices is the plural. Don't give me two different ways to spell it, that would give rise to debates like this for no good reason.

Nick