Hash index example plan

- [Instructor] Okay, let's see how to create a hash index. … I'm going to use the email column of the staff table … as my example. … Now, the email column is a good candidate … since the email should be unique to each person, … and it's likely we want to be able … to look up a person's staff data by their email. … Also, it's not likely that we'd want to perform … a range query on the email addresses. … So let's create a hash index. … We use the create index command, and we give it a name, … we specify the term ON followed by the table name. … Now, instead of just specifying the column name here, … I'm going to specify USING HASH and then … specify the column name. … And let's execute that. … So we've created a hash index. … Now let's see if it actually gets used. … And to do that, we're going to use as our example … SELECT * FROM staff WHERE email is equal to … and we'll use bphillips and let's just execute that, … make sure I got it correct. … Bphillips, oh excuse me, it's bphillips5 I believe. …