PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Collapse]Settings
    [Expand]Subjects
    [Expand]Items
    [Expand]POS
    [Expand]Manufacturing
    [Expand]Personnel
     Calendar
    [Expand]Financials
    [Expand]Customs
    [Collapse]Program
     [Expand]Document Types
     [Expand]Reports in PANTHEON
      Document Texts
      Delivery Methods
     [Expand]Loyalty Cards
     [Collapse]Administration Panel
      [Expand]Right click on Administration panel tree
      [Expand]Settings
      [Expand]Security
       Menu
      [Expand]Users and Groups
      [Expand]Versions/Upgrades
      [Collapse]Database
       [Expand]Company Settings
       [Expand]Backup
        Statistics
       [Collapse]Performance
         Top N=20 Queries - I/0
         Top N=20 Queries - CPU
         Cache
        [Collapse]Edit Indices
          Databases
          Fragmentation
          Missing/Redundant Indexes
          Primary Key
          Logs (incl upgrades)
         Data Errors
         Locked Records
         Form Opening Measurements
         Ping/Trace
        Referential Integrity Check
       [Expand]Import/Export Data
       [Expand]Document Links and Transfers
        System Log
       [Expand]Changelog Settings
        Report Log
        Event Log
        Document archiving
       [Expand]Workflow Log
      [Expand]ZEUS
      [Expand]OTOS
     [Expand]Dashboard Components
      Dashboard Reports
      Ad-hoc analysis
     [Expand]ARES
      SQL urejevalnik
    [Expand]Documentation
    [Expand]Change User
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Expand]Financials
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 703.1293 ms
"
   1000006135 | 225547 | 412493 | Published
Label

Missing/Redundant Indexes

     

The Missing/Redundant Indexes panel allows seraching, creating missing indices and and preview redundant indexes.

HINT

Redundant means superfluous or unnecessary. In the context of computing and databases, it often refers to data or components that are duplicated or unnecessary because there are other data or components that provide the same functionality or information. Redundancy can be used to improve system reliability, as duplicate components can serve as backups in case of failure.

 

The functionality is accessed on Performance | Edit Indices panel in Administration panel.

 

The following is a description of the functionality of the form.

Table of contents

  1. Missing/Redundant Indexes table
  2. Food of Missing/Redundant panel

 

1. Missing/Redundant Indexes table

 (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 - collapse all selected indices.
  • Expand All for Selection -  expand all selected indices.
  • 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. Foot of Missing/Redundant panel

 

Reset

By clicking, you can delete selected indices. 

WARNING

This operation in irreversible.
Create By clicking, create missing indexes.

 

RELATED TOPICS:

  Top N=20 Queries - I/O

  Performance

  Primary Key

  Database

 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!