Hi,
I am confused with my superior how he understands Progress DB Index.
How I understand the logic of creating indexes is something like these.
Table: Person
Field1: FirstName
Field2: LastName
Index: NameIndex
Index
What I believe is when I query the records of this table using only one field for filter (e.g. Firstname only), your query performance is slower than using both Fields in the Index (Firstname & Lastname) and this opposed to what my superior knows:
For him, using only 1 field for filter makes same performance with using both fields in Index.
I am confused because I have tested this before in a 100,000 - 200,000 records before.
Can someone enlighten me?
Thanks Guys
I am confused with my superior how he understands Progress DB Index.
How I understand the logic of creating indexes is something like these.
Table: Person
Field1: FirstName
Field2: LastName
Index: NameIndex
Index
Table Name | Person |
Fields | Firstname,Lastname,Age |
Index | NameIndex |
Index Fields: Firstname,Lastname |
What I believe is when I query the records of this table using only one field for filter (e.g. Firstname only), your query performance is slower than using both Fields in the Index (Firstname & Lastname) and this opposed to what my superior knows:
For him, using only 1 field for filter makes same performance with using both fields in Index.
I am confused because I have tested this before in a 100,000 - 200,000 records before.
Can someone enlighten me?
Thanks Guys