As with most items concerning SQL and for your specific question "It depends", is in some regards the universal answer.
Now to obtain further details for various situations such as database activity (insert of new data, deletion/updating of already entered data) I suggest you read:
And in particular the section titled: What are the performance implications?