Re: DB2 - Index

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

-----Original Message-----
From: AKumar@rccl.com <AKumar@rccl.com>
To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com>
Date: Friday, July 14, 2000 3:24 PM
Subject: DB2 - Index


>
>Hi,
>     I am trying to use different indexes in stored procedure to maximize
>the performance .
>There are three choices of creating index.
>CASE I) Create logical file.
>CASE 2) CREATE INDEX ..........
>CASE 3) CREATE ENCODED VECTOR INDEX..........
>
>Q 1) What kind of index is created when we create Logical File?

The standard kind, like create index, not the EVI. EVIs are only available
thru the SQL interface.

>Q 2) If there is some thumb rule (or rule) which I need to follow during
>going for a index?
>

Rule of Thumb: index what you use to search on.
Rule of Thumb: index what you use to select on.
Rule of Thumb: index what you use to sort on.

As for rules, there are far too many to just post them on this list.

>It is very important for us.
>


and everybody else that uses database.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"Those who would give up essential Liberty,
  to purchase a little temporary Safety,
  deserve neither Liberty nor Safety."

     - The Papers of Ben Franklin



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---