Kbase 21096: ROWID Record Retrieval Explained
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/16/2004 |
|
Status: Verified
GOAL:
Index selection process when retrieving a row using ROWID explained.
GOAL:
ROWID Record Retrieval Explained
GOAL:
How does the ROWID is used to retrieve records?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
The example uses the CUSTOMER table which has following indexes:
Index Name Index Columns Unique
------------ --------- ------------------- ----------
Cust-Num (Primary) CustNum Yes
Name Name No
Sales-Rep Sales-Rep No
Country-Post Country,Postal-code No
Comments Comments Word Index
If you retrieve a row using ROWID, Progress will directly retrieve the row by using the rowid and will not use an index.
FIND customer WHERE ROWID(customer) = rowid-customer.
INDEX USED: None
The row is directly retrieved using the rowid. This is the only way a row can be retrieved without using any index at all.