Saminnet-Search Article Wiki Forum Piwigo SNS Cloud vtiger Sugar
DB2 Indexes

  • Data-Articles
    • Desa Nelayan Makmur (166) Fri02,20:43pm

      KALAUツdilihat Desa Bendar tidaklah berbeda dengan desa-desa lainnya. Berada di tepi sungai Juwana, kecamatan Juwana, kabupaten Pati, Jawa Tengah. Pun, tempat ini memiliki pelelangan ikan pula. Yang membedakan dengan desa-desa nelayan lainnya adalah rumah-rumah kokoh dan besar. Ya, desa nelayan ini bukanlah sembarangan desa nelayan. Kebanyakan warga desa ini adalah pengusaha kapal penangkap ikan.…

      Read More...

DB2 Indexes

This chapter covers introduction to indexes, their types, creation and dropping.

Introduction

Index is a set of pointers, which can refer to rows in a table, blocks in MDC or ITC tables, XML data in an XML storage object that are logically ordered by the values of one or more keys. It is created on DB2 table columns to speed up the data access for the queries, and to cluster and partition the data efficiently. It can also improve the performance of operation on the view. A table with a unique index can have rows with unique keys. Depending on the table requirements, you can take different types of indexes.

Types of indexes

  • http://www.tutorialspoint.com/images/icon-bullet.png) 0px 4px no-repeat;">Unique and Non-Unique indexes
  • http://www.tutorialspoint.com/images/icon-bullet.png) 0px 4px no-repeat;">Clustered and non-clustered indexes

Creating indexes

For creating unique indexes, you use following syntax:

Syntax:

db2 create unique index <index_name> on 
<table_name>(<unique_column>) include (<column_names..>)

Example: To create index for 窶徭hopper.sales1窶 table.

db2 create unique index sales1_indx on 
shopper.sales1(id) include (itemname)

Dropping indexes

For dropping the index, you use the following syntax:

Syntax:

db2 drop unique index <index_name> on 
<table_name>(<unique_column>) include (<column_names..>)

Example:

db2 drop index sales_index 

Add comment


Category Database

TweetTweet Share on LinkedInShare on LinkedIn Share on Google+Google+ Submit to RedditReddit Publish on WordPress WordPress Send emailSend email