Updating datbase

Updates query optimization statistics on a table or indexed view.By default, the query optimizer already updates statistics as necessary to improve the query plan; in some cases you can improve query performance by using UPDATE STATISTICS or the stored procedure sp_updatestats to update statistics more frequently than the default updates.Updating statistics ensures that queries compile with up-to-date statistics.However, updating statistics causes queries to recompile.

A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases.Android provides many ways to store data, SQLite Database is one of them that is already include in android OS. List; public class DBHandler extends SQLite Open Helper As we have written our DBHandler class completely let use it in our application. We have to just simply use it according to our need. And when we talk about android so SQLite is that default feature which is used as a database and also used as a local database for any application. If you are unable to see Logs then go to View Mobile is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon and the Amazon logo are trademarks of Amazon.com, Inc. This tutorial shows a very simple example which is to just store important data like shops address or contacts using SQLite Database in the android studio.