Home » SQL & PL/SQL » SQL & PL/SQL » indexes-any limit?
indexes-any limit? [message #19836] Fri, 12 April 2002 03:56 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
any limit on the number of indexes for a table?

Report message to a moderator

Re: indexes-any limit? [message #19837 is a reply to message #19836] Fri, 12 April 2002 04:08 Go to previous messageGo to next message
Epe
Messages: 99
Registered: March 2002
Member
Hello,

as far as I know there is no limit.
But beware, too many indexes on one table may harm performance...

Success,

epe

Report message to a moderator

Re: indexes-any limit? [message #19852 is a reply to message #19836] Sat, 13 April 2002 14:15 Go to previous message
Su
Messages: 154
Registered: April 2002
Senior Member
As per ORACLE8i, a maximum of 16 columns in a table can be indexed. But remember, as the number of indexes on a table grows, you trade-off the performance on a table which may need frequent data update and/or insertion. I guess, there is also a limit on how many indexes can be created on a table. Any one has an idea?

Report message to a moderator

Previous Topic: BULK COLLECT AND TABLE JOINS.. please help!!
Next Topic: Vertical display of unrealted columns
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 21:51:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.