Create an index

- [Narrator] In this section, we are going to look…at creating an index and then look at some…of the performance benefits of that index.…First, we'll need to create a testing table…and insert some data into that table.…So I've staged some code for you…to do this in your exercise files,…if you want to take the top half of that…and copy it into a new query window.…This is going to create a new table called IndexTest.…There will be two columns in that table,…a text column and a number column.…Then we're going to loop through 10,000 times…and insert one row of data each time.…

Into the number column, I'm inserting…a random value between one and five hundred.…Then we'll run some queries on that column…and create an index on that column.…So I'll go ahead and execute this.…And once that's run, we can go ahead and query this data.…I'll go back to the exercise file…and this time copy the bottom half…into a new query window.…The top half of this, with the checkpoint…and the dropcleanbuffers is just…creating a clean system for me.…