Re: DB2 - Index

The CRTLF command creates an index similar to the Create Index or Create
View command in SQL the Create Encoded Vector Index creates a special index
that is useful primarily in the decision support arena. You can not read an
EVI directly nor does it support sequencing. Check out the IBM web site (
www.as400.ibm.com ) and do a search for EVI or Encoded Vector Index.

______________________________________________
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St.
Tacoma WA 98407


----- Original Message -----
From: <AKumar@rccl.com>
To: <MIDRANGE-L@midrange.com>
Sent: Friday, July 14, 2000 11:07 AM
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?
> Q 2) If there is some thumb rule (or rule) which I need to follow during
> going for a index?
>
> It is very important for us.
>
> Regards,
> Ajay Kumar
> 305-539-6621.
>
>
> +---
> | 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
> +---

+---
| 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
+---