MySQL with many NULL column attributes

[edh]

Hello:

Can someone tell me how a database schema with many columns that have many NULL (empty) attributes effects the datbase performance, etc.?

I have a table with about 100,000 records and about 90-95% of the fields are NULL.

It would take alot of work, but should I consider a redesign and split the table into many tables that are full?

Thanks.

Ed

[LordShryku]

If you have that many fields that are null, then yes, you should definately look at a redesign. When performing a query, enforcing a full table scan, it's going to look in those fields regardless of them being null.