kalaiarasan
Member
If we were increase a field in temp-table index either primary or not . do we get performance improvement in a query
coded below primary with one field and next one with three field
& similiary non primary index too
/* primary index */
eg Define temp-table tablename no-lock
field1 as char
field2 as char
field3 as char
field4 as char
index index1 is primary
field field1
eg Define temp-table tablename no-lock
field1 as char
field2 as char
field3 as char
field4 as char
index index1 is primary
field field1
field field2
field field2
/* non primary index */
eg Define temp-table tablename no-lock
field1 as char
field2 as char
field3 as char
field4 as char
index index1
field field1
eg Define temp-table tablename no-lock
field1 as char
field2 as char
field3 as char
field4 as char
index index1
field field1
field field2
field field2
coded below primary with one field and next one with three field
& similiary non primary index too
/* primary index */
eg Define temp-table tablename no-lock
field1 as char
field2 as char
field3 as char
field4 as char
index index1 is primary
field field1
eg Define temp-table tablename no-lock
field1 as char
field2 as char
field3 as char
field4 as char
index index1 is primary
field field1
field field2
field field2
/* non primary index */
eg Define temp-table tablename no-lock
field1 as char
field2 as char
field3 as char
field4 as char
index index1
field field1
eg Define temp-table tablename no-lock
field1 as char
field2 as char
field3 as char
field4 as char
index index1
field field1
field field2
field field2