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

Building Scalable Systems - Handling Hyper-Growth

Hyper-growth is one of the most exhilarating phases for any business, marked by rapid expansion, new opportunities, and an undeniable sense ...