Skip to Content
0
Former Member
Jul 30, 2007 at 12:14 PM

Secondary index in DSO

181 Views

Hi,

If i am creating secodary index on DSO..There r two types Unique and Non-unique index..

What is the difference between these two index.Explain with one example.

While creating index naming is coming like 010,020,030..like this ..Is there any purpose for this naming convention.

Also In my DSO

Keyfield-F1

Datafield-S1,S2,S3,S4

So primary index is automatically created for F1,but if i generated a query based on S1..How will be the query performance

If i am creating secondary index based on S1 and generating query..How will be the performance..

How to check performance difference between these two queries (i.e with and without secondary index on S1)..

Regards

Prakash