Skip to main content
  • Log in
  • twitter
  • linkedin
  • facebook

Dataprix main menu

  • Blogs
  • Software
  • News and resources
Home

Main tematic navigation

  • Business Intelligence
  • Data Science
  • Cloud
  • Databases
  • Security
  • ERP

Software

Huawei Gauss DB

Huawei GaussDB is an enterprise-class AI-Native distributed database that uses the massively parallel processing (MPP) architecture.

GaussDB supports both row and column-oriented storage and is capable of processing petabytes of data. GaussDB offers a cost-efficient, general-purpose computing platform to manage massive data sets and is compatible with a wide range of data warehousing systems, business intelligence (BI) systems, and decision support systems (DSS).

Huawei GaussDB integrates AI technology into the database kernel architecture and algorithms, providing users distributed databases with higher performance, higher availability, and more diverse computing power.

Más software empresarial

Documentación y recursos

How to repair SQL Server databases with Stellar Repair MS SQL

How to Repair Corrupt SQL Database with the help of Stellar Repair for MS SQL software.Most Recommended software by MVP's and administrators to repair corrupt MDF and NDF files. It recovers tables, triggers, indexes, keys, rules and stored procedures. It supports SQL Server 2017, 2016, 2014, 2012, 2008, 2008R2 and all lower versions.

The beginners guide to NoSQL

Beginners guide to NoSQLTake advantage of noSQL by learning the basics and more with this FREE eBook offered by Robert Gordon University that includes:

  • An introduction to noSQL
  • The four different types of noSQL database that exist
  • The difference between SQL and noSQL and which to choose for your work

 

Más recursos sobre software empresarial

Entradas de blog

Detecting indexes, tables and packages not used on DB2

By Oscar_paredes on Mon, 02/10/2020 - 19:53
  • Read more about Detecting indexes, tables and packages not used on DB2
  • Log in or register to post comments

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
Más videos IT

Publicaciones en la red

Integration of Regional WAF with Logging Analytics

In this blog, we are going demonstrate on how to integrate OCI Regional WAF with another native service Logging Analytics and get better security insights about your traffic. We will cover all required steps and be as detailed as possible and also give screenshots for easier navigation. At the end, you can find WAF Dashboards resources which covers all countermeasures that are available right…

Read on:

https://blogs.oracle.com/post/integration-of-regional-waf-with-logging-…

Crisdu quer que e-commerce represente 25% de sua receita em
dois anos com Oracle

Oracle foi escolhida a partir da qualidade do atendimento e do histórico de desempenho da solução

Read on:

https://blogs.oracle.com/post/crisdu-quer-que-e-commerce-represente-25-…

More publications from the net

Promoted Resources

Today's Top Picks for Our Readers:
Recommended by Recommended by NetLine

Popular today

Useful Oracle SQL queries and scripts

Don't you have a chop with useful queries to use in your daily adventures and desventures with the database? I include in this first post a…

How to do an update from a select with summarized registers in SQLServer

A very powerful way to do a table's update in a SQL Server database is to link it with another table with a join, and updating the fields…

Avoiding errors concatenating fields with numerical values in SQL Server

The operator to concatenate in SQL Server is '+', but this operator is also used to add values.   Being the same operator for both, the…

Data Warehouse Security Best Practices

Data warehouse security is vital for organizations that take the huge step of collating all their important data in one place. Unauthorized…

db2look – Create DDL for table or full schema

Db2look is an utility to extract the definition of database objects.

Easily export data from Oracle to flat file

A simple way to export data from a query, table, etc.. of an oracle database to a flat file is to use the SPOOL command in SQLPlus. This…

Pentaho BI Suite

  Pentaho was created in 2004 and at this moment, it is the leader of the Open Source BI solutions. It offers a large spectrum of resources…

How to access from SQL Server to MySQL databases

We could need to access to MySQL from SQL Server. An easy way to do it is creating a linked server that uses an ODBC connection..  

Options db2 command line – Disable autocommit

DB2 command line utility has different options.

How to know the DB2 connection port

Maybe there are other methods, in this short article, a simple way to know the port that serves DB2 server.

Breadcrumb

  1. Home
  2. Databases

Creative Commons License  This work is licensed under a Creative Commons Attribution-Share Alike 3.0 Unported License.

Footer menu

  • Contact
Clear keys input element