|
-
10 indexes on the same column within the same table is bad any way you slice it!
10 indexes on different columns within the same table makes sense.
I'd second slimdave's comment to look at the code. You might be able to drop an index or two or concatenate some.
10 indexes on a DW table is not too uncommon, especially if ad-hoc queries are being thrown at it.
Last edited by KenEwald; 06-12-2003 at 04:56 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote