What are the types of PI (Primary Index) in Teradata?

The Teradata Primary index is not an index in the traditional sense, as it is not a lookup table. Instead, it is a mechanism that defines w...

How and Why To Bridge between SQL and NoSQL

SQL have for long now been the synonym of "database" for us. For any sort of data management, SQL had been our instinctive choi...

How to Drop Indexes/ Unique Indexes in Oracle?

There can be multiple situations where we don�t require indexes and have to drop them. Sometimes it�s better to drop the indexes when there...

Oracle Indexes Performance and Creation Guidelines

These guidelines will help you create and manage indexes and help improving the performance by correct usage of indexes. DON�T ADD INDEXES W...

Advantages of MongoDB over RDBMS

The Advantages of MongoDB over RDBMS are No schema migrations. Since MongoDB is schema-free, your code defines your schema. Number of fields...