Software

Editor de consultas SQL de Apache Hive

Hive is a software that works on Hadoop clusters creating a layer that allows the developer to abstract from the management of HDFS and MapReduce files through SQL-based data query operations, with the HiveQL language...

Más software empresarial

Entradas de blog

Detecting indexes, tables and packages not used on DB2

By Oscar_paredes on Mon, 02/10/2020 - 19:53

DB2, from version 9.7, allows to know easily what indexes are not being used in a Database. The query is also for tables and packages.

This is a useful tool for tuning indexes and detecting problems in their use.

After version 9.7 DB2 includes a new LASTUSED field in the SYSCAT.INDEXES, SYSCAT.TABLES and SYSCAT.PACKAGES tables.

This field indicates the date of last use of indexes, tables or packages.

For example, to query unused indexes since 1/1/2019, you could use this simple query:

more posts

Noticias de Databases

Main types of database management systems:  Hierarchical Databases Network Databases Relational Databases…
How to Repair Corrupt SQL Database with the help of Stellar Repair for MS SQL software.Most Recommended software by MVP…
  Take advantage of noSQL by learning the basics and more with this FREE eBook offered by Robert Gordon University  …
Más noticias
More publications from the net

Prueba Semrush gratis 14 días!