Hello There

I just want to ask a quick question of you all.

Do you have any insights on the following?

What are the Postives & Negatives of creating a large
table on a database with around 500 fields.

Also this table could have up to 6-8 million records.

This Table would also have to have a lot of indexes & get appended to on a daily basis?

Many Thanks For any advice recieved....