From the course: Oracle Database 19c: Basic SQL
Join today to access over 24,700 courses taught by industry experts.
Creating indexes
From the course: Oracle Database 19c: Basic SQL
Creating indexes
- [Instructor] Whether your role is a developer, DBA or report writer, at some point, you'll want to create an index on a table, either for faster access or column constraints. In this video, I'll tell you how indexes fit in with the other database object types, what columns you can put in an oracle database, 19c index, and how to constrain column values. First, here's an overview of database objects and how tables fit into that list of objects. An object is something owned by a schema, AKA a user, and can be created and manipulated by SQL statements. Here are the most common types of database objects you gon' use on a regular basis. Tables, indexes, views, synonyms, and so forth. Almost every table will have some type of index to make it easier or faster to retrieve the rows found in a table. Before I demonstrate how to create an index, you need to know the rules for valid index names and for the columns in the table. The rules are straightforward, up to 128 characters long, contain…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.