Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Creating Tables, Sequences, Indexes, and Views

Chapter 10. Creating Tables, Sequences, Indexes, and Views

In this chapter, you will

  • Learn more about tables

  • See how to create and use sequences; a sequence generates a series of numbers

  • Explore how to create and use indexes; an index can improve the performance of queries

  • Learn how to create and use views, which are predefined queries on one or more tables; among other benefits, views allow you to hide complexity from a user, and implement another layer of security by only allowing a view to access a limited set of data in the tables


  

You are currently reading a PREVIEW of this book.

                                                                                        

Get instant access to over
$1 million worth of books and videos.

  

Start a Free Trial