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

  • Data-Articles
    • Baja iwf (107) Sun09,20:21pm

      sesuai post saya yang terakhirツdisini, rumah dua pohon sedang dalam pembangunan tahap 2 dengan material utama menggunakan baja. baja adalah material konstruksi yang paling padat apabila dibandingkan dengan beton dan kayu karena memiliki berat satuan yang cukup besar. karena baja bisa difabrikasi di pabrik, pemasangan di site bisa lebih cepat dibandingkan dengan beton yang mesti dicetak dan ditun…

      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