Customized Remote Work Solutions From the World’s Largest Fully Remote CompanyCustomized Remote Work SolutionsLearn More

Oracle

Showing 1-4 of 4 results
EngineeringIcon ChevronBack-end

SQL Indexes Explained, Pt. 2

by Mirko Marović

Sorting a table can make some queries faster—but the maintenance cost is untenable. Enter real database indexes and their most common implementation structure: the B-tree.

10 minute readContinue Reading
EngineeringIcon ChevronBack-end

SQL Indexes Explained, Pt. 1

by Mirko Marović

Properly used, an SQL database index can be so effective that it might seem like magic. But the following series of exercises will show that underneath, the logic of most SQL indexes---and wielding them correctly---is quite straightforward.

8 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Oracle to SQL Server and SQL Server to Oracle Migration Guide - Pt. 3

by Leonid Draginsky

Migrating in either direction between Microsoft SQL Server and Oracle Database? Code migration tools, public synonyms, and change management are important to keep in mind.

14 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Oracle to SQL Server and SQL Server to Oracle Migration Guide - Pt. 2

by Leonid Draginsky

Migrating in either direction between Microsoft SQL Server and Oracle Database? This round of pitfalls to avoid includes coverage of sequences, identity columns, and filtered indexes.

8 minute readContinue Reading

Join the Toptal® community.