the airport table has two thousand rows. the airline table has ten thousand rows. both tables are updated infrequently. should airport and airline be stored in the same tablespace?

See Answers (1)

Suggested Answer

Sometimes airport and airline be stored in the same tablespace. A storage structure called a table space houses tables, indexes, big objects, and long data. What is tablespace?The real data that underlies database objects can be stored in a tablespace. It serves to allot storage for all DBMS managed segments and offers a layer of abstraction between logical and physical data. When generating database segments, a tablespace can be referred to by name once it has been formed.A storage structure called a table space houses tables, indexes, big objects, and long data. They are employed to categorize information in a database into logical storage groups that correspond to the locations of the information on a system. Database partition groups hold table spaces.The database storage unit known as a tablespace is comparable to a file group in Microsoft SQL Server. Database items can be managed and stored in separate groups using tablespaces. To learn more about tablespace refer to:https://brainly.com/question/12162314#SPJ4

Related Question in Computers and Technology