| Subject | too many keys defined for index |
|---|---|
| Author | tdtappe |
| Post date | 2005-03-17T07:49Z |
I get this error when I try to create an index via
CREATE INDEX SomeIndex ON SomeTable(COLUMN1, COLUMN2)
Both columns are SMALLINTs. The table has about 2 million records.
If I try to do this on a different database with the same metadata,
everything seems to be fine.
What does this error mean? How can I get around this?
--Heiko
CREATE INDEX SomeIndex ON SomeTable(COLUMN1, COLUMN2)
Both columns are SMALLINTs. The table has about 2 million records.
If I try to do this on a different database with the same metadata,
everything seems to be fine.
What does this error mean? How can I get around this?
--Heiko