Home » SQL & PL/SQL » SQL & PL/SQL » Index
Index [message #8604] Wed, 03 September 2003 08:35 Go to next message
saravanan
Messages: 70
Registered: October 2000
Member
How many Indexs possible in a table
Re: Index [message #8607 is a reply to message #8604] Wed, 03 September 2003 09:02 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
quote from Saravanan:
----------------------------------------------------------------------
How many Indexs possible in a table

----------------------------------------------------------------------
From this Ask Tom discussion,
----------------------------------------------------------------------
I've never heard of a "limit", suggested or otherwise, as to the maximum number of indexes per table.

It is true that each index will cause an INSERT/DELETE and maybe an UPDATE (if you update the indexed columns) to run slower.

----------------------------------------------------------------------
A.
Previous Topic: Column in Table
Next Topic: PL/SQL table compare with temporary table
Goto Forum:
  


Current Time: Fri Apr 26 21:09:19 CDT 2024