> For the complete documentation index, see [llms.txt](https://docs.docbits.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.docbits.com/administration-and-setup/settings/global-settings/document-types/table-columns/purpose-and-use.md).

# Purpose and Use

## Setting up table columns correctly is critical to ensure efficient data storage, querying, and reporting.

**Here are the main reasons why:**

**Space optimization:**

* Carefully selecting and arranging columns can help you minimize the amount of space your database requires.
* This is especially important when working with large amounts of data, as unnecessary or redundant columns can waste resources.

**Data consistency:**

* By ensuring that each column only contains data that is relevant to its specific purpose, you can improve the consistency of your database.
* This means that your data is cleaner and more reliable, which in turn improves the quality of your reporting.

**Query performance:**

* Well-designed table columns can significantly improve the performance of database queries. For example, putting indexes on frequently queried columns can help queries run faster.
* Avoiding unnecessary columns in query results can also increase query performance.

**Easier reporting:**

* Organizing your data into meaningful column structures makes it easier to create reports and analyses.
* Well-designed table columns can also increase the readability of reports and ensure that important information is easy to find.

**Future-proofing:**

* By setting up the right table columns from the start, you can better prepare your database for future needs.
* You can more easily add new features and make changes to the data model without affecting existing data.

Overall, setting up table columns correctly helps improve the efficiency, consistency and performance of your database, which in turn increases the quality of your data storage, querying and reporting.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.docbits.com/administration-and-setup/settings/global-settings/document-types/table-columns/purpose-and-use.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.