DB2 - Index

[AKumar@xxxxxxxx]

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