What does the Index field actually do?

1

I couldn’t find an answer to this in the Frappe Framework document.

I assume checking the field will result in data getting indexed in the db.

1000020634
10000206341147×1573 78.4 KB

2

@Muzzy Indexing a field (or column) in a database table means creating a data structure that improves the speed of data retrieval operations for that field. An index works like a lookup table that allows the database to locate data quickly without scanning every row in the table.

1 Like
3

Thank you. I am aware of what you stated. My question us does the check box leads to db index of the field or it has some other purpose?

4

It is exactly that, db index.

1 Like