Consultor Eletrônico



Kbase P80059: Does a PRESELECT query cause database reads?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   5/11/2004
Status: Unverified

GOAL:

Does a PRESELECT query cause database reads?

FIX:

Yes, it does. We have to build the result list of ROWIDs and this may require reading of database records along with index records depending on the WHERE clause of the query.