How to quickly restart adb.exe

Step (1). Add this ( or where ever is your “platform-tools” folder located ) path to environment variables path. C:\Users\mm-admin\AppData\Local\Android\sdk\platform-tools Step (2). Open cmd and run these commands : adb kill-server && adb start-server and press enter. This will kill existing broken server running if any, then re-start with the default port assigned. This will Read More

Tuning advisors

How to use SQL Access Advisor?

SQL Access Advisor suggests proper set of materialized views,partitioned tables,indexes for given workload. Complex tasks such as partition of an unpartitioned table needs a go through for access advisors. Here I will suggest how to use access advisor for each component. In case of views, as a virtual table does not hold any data. Every Read More