In today’s article, we will discuss the B-tree index, which is a balanced tree data structure used to store indexed values ​​in a sorted order. It is one of the most used index types in database systems. It is one of the default index types in Oracle, MSSQL and PostgreSQL. Different index types can be … The post B-Tree Index In PostgreSQL first appeared on Database Tutorials. The post B-Tree Index In PostgreSQL appeared first on Database Tutorials ..read more

In today’s article, we will be learning how to Logging and Nologging the Table in the Oracle database. The logging_clause lets you specify whether certain DML operations will be logged in the redo log file (LOGGING) or not (NOLOGGING). We can log while creating the table or later. Logging / nologging while creating the table; … The post Table Logging And Nologging first appeared on Database Tutorials. The post Table Logging And Nologging appeared first on Database Tutorials ..read more

In this tutorial, you will learn about various PostgreSQL index types and how to use them appropriately. PostgreSQL has several index types: B-tree, Hash, GiST, SP-GiST, GIN, and BRIN. Each index type uses a different storage structure and algorithm to cope with different kinds of queries. B-Tree İndex It is used for equality and range … The post PostgreSQL Index Types first appeared on Database Tutorials. The post PostgreSQL Index Types appeared first on Database Tutorials ..read more

In today’s article, we will be learning how to Create a Virtual Column in Oracle Database. Virtual column value cannot be UPDATE. INDEX can be created on virtual columns and used in WHERE condition. The virtual column can be created as follows; [crayon-669139321681d287077541/] The post Create Virtual Columns In Oracle first appeared on Database Tutorials. The post Create Virtual Columns In Oracle appeared first on Database Tutorials ..read more

In today’s article, we will be explaining how a database search engine can use indexes to speed up data retrieval. For example, if you want to reference all pages in a book that discusses a certain topic, you have to first refer to the index, which lists all topics alphabetically and then refer to one … The post PostgreSQL INDEXES first appeared on Database Tutorials. The post PostgreSQL INDEXES appeared first on Database Tutorials ..read more

In today’s article, we will talk about how to use the SET UNUSED command in cases where dropping the column will take time. We use SET UNUSED in cases where dropping the column will take time. The columns used with this expression are not actually deleted but are marked as unused. Columns marked as unused … The post SET UNUSED In Oracle first appeared on Database Tutorials. The post SET UNUSED In Oracle appeared first on Database Tutorials ..read more

In today’s article, If you are getting the “Microsoft Cluster Service (MSCS) cluster verification errors” failed while setting up SQL Failover Cluster, we will learn how to solve it. ”Rule “Microsoft Cluster Service (MSCS) cluster verification errors” failed. The cluster either has not been verified or there are errors or failures in the verification report. … The post “Microsoft Cluster Service (MSCS) cluster verification errors” failed first appeared on Database Tutorials. The post “Microsoft Cluster Service (MSCS) cluster verification errors” failed appeared first on Database Tutorials ..read more

In this article, we will discuss in detail the table Move processes and how Shrink operations are performed. Sometimes we may need to move a table to another tablespace. For example, we may want to do Shrink operation. However, in order to perform the shrink operation, the “SEGMENT SPACE MANAGEMENT” value of the table must … The post Table Move And Shrink first appeared on Database Tutorials. The post Table Move And Shrink appeared first on Database Tutorials ..read more

In this tutorial, you will learn how to use the PostgreSQL DELETE TRIGGER statement to delete a trigger from a table. First of all, we need to create a function or procedure before creating the trigger. The purpose of doing this is that we will be performing the action to be performed in the create … The post PostgreSQL DELETE TRIGGER first appeared on Database Tutorials. The post PostgreSQL DELETE TRIGGER appeared first on Database Tutorials ..read more

In today’s article, we will learn how to delete data from a table and the differences between DELETE and TRUNCATE commands. Data from a table can be deleted with DELETE and TRUNCATE commands. But there are differences between them. These differences are as follows. By default, Oracle deals (deallocates) the space held by the table … The post Delete Data From The Table first appeared on Database Tutorials. The post Delete Data From The Table appeared first on Database Tutorials ..read more