Avatar of websss
Flag for Kenya

asked on 

table size and performance

I have a table with 38 columns
I now need to add another 9 columns or more
or move them to a separate table

The table has millions of rows and is accessed quite a lot (like every 30 secs by 200 users), so i'm thinking by adding more columns to this table will really impact performance, but i'm not sure
can someone help clarify is this is a big NO NO or whether it will be fine adding these on same table
Microsoft SQL Server

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon