A physical database is a refinement of the logical database design. In this phase, you examine how the user will access the database, and refine the database design by answering questions like:
What data will I commonly use?
Which columns in the table should I index based on data access?
Where should I build in flexibility and allow for growth?
Should I denormalize the database to improve performance? A database is typically denormalized at this stage to meet performance requirements.
What data will I commonly use?