Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Too Many Indices?

Status
Not open for further replies.
NaughtyVicar

NaughtyVicar

MIS
Jun 4, 2002
16
US
Hi all, newbie here. Is it possible to have "too many" indices on a table? In a data warehousing environment, if I have a customer table with 100 fields, and I put an index on 50 of them (assuming of course that an index would be warrented) will the sheer number of indices slow the database down?

Much thanks in advance!
 
Status
Not open for further replies.

Similar threads

ihda
  • Locked
  • Question
One To Many - Single Row Query Selection
Replies
1
Views
64
BJCooperIT
BJCooperIT
ihda
  • Locked
  • Question
One-to-many Data Combined on a Single Row
Replies
0
Views
48
ihda
ihda
danmul
  • Locked
  • Question
Record Group too slow on forms6i
Replies
3
Views
45
lewisp
lewisp
ingresman
  • Locked
  • Question
forms migration tools
Replies
0
Views
40
ingresman
ingresman
abidali3
  • Locked
  • Question
How many Cursor style.
Replies
4
Views
38
abidali3
abidali3

Part and Inventory Search

Sponsor

Back
Top