Search This Blog

Tuesday, January 5, 2010

%UpdateStats in peoplecode

%updateStats is used to update Index table (database table) which stores key row (Like ROWID, INDEXFIELD DATA) information. Once you execute above statement your table & system table are sync. By above command index in query works properly and fetches data faster.

No comments:

Post a Comment