Primary Key
Primary Key is a unique identifier of an individual row or record in a database table. It is an attribute or a combination of attributes that uniquely identifies each row in the table. The primary key is crucial for ensuring data integrity and enables efficient querying, updating, and linking of data across different tables in the database.
The Primary Key panel allows serchning and creating primary keys in databases.
The functionality is accessed on Performance | Edit Indices panel in Administration panel.
menjat sliko
The following is a description of the functionality of the form.
1.
 (Plus) |
By clicking, the following options are available:
- Collapse All - collapse whole fragmentation table.
- Expand All - expand whole fragmentation table.
- Collapse Selected - collapse only selected indices in fragmentation table.
- Expand Selected - expand only selected indices in fragmentation table.
- Collapse All for Selection - ??
- Expand All for Selection - ??
- Select All - select all indices in fragmentation table.
- Undo Merge - restore to the original state before merging.
|
| Search |
By clicking, all indexes that are missing or redundant, will be collected. |
| Database |
Database where are tabel with indices for fragmentation. |
| Table |
Table where are indices for fragmentation. |
| Sel. |
By clicking, index is selected ( ). |
| Index |
Name of index. |
2.
| Create |
Create missing primary keys in database. |