Benefits of Multi threading

• Maximum Throughput: Maximum throughput can be achieved using multiple threads fueling application performance which can be achieved using multi-threaded application and CPU multiple cores.

• Parallel Processing: In multi-threading environment task gets processed in parallel mode which improves application capacity to process more requests volume.

• Better User Experience: Multi-threading undoubtedly provides better user experience by enhancing application performance capability.

Creating index in oracle database | Database Performance tuning

Indexes are used to quickly locate data without having to search every row in the database table each time a database table is accessed.
Indexes can be created using one or more columns of a database table, providing the basis for both rapid or random lookup and efficient access of ordered records.
Index is a data structure that improves the speed of data retrieval operations on a database table.

How to create index:
  create index <index_name> on <table_name> (<col1>,<col2>,...);

So, if you want to create index on color column on your paint table and call it paint_color_i, SQL would look like below:
  create index paint_color_i on paint (color);

You can also include more column to index like below:
  create index paint_color_i on paint (color,type);

How to configure SSH Server on Ubuntu

1. Installing SSH Server:

• openssh-server package can be found in linux software center. Alternatively open terminal and run below command.

          sudo apt-get install openssh-server

2. Enabling SSH on Ubuntu:

• Once ssh installed on the machine create backup of sshd_config file with sshd_config.defaults filename to restore in case configuration is messed up.

       sudo cp /etc/ssh/sshd_config /etc/ssh/sshd_config.defaults

    

    Change permission of defaults backup file using chmod command given             below.

    sudo chmod a-w /etc/ssh/sshd_config.defaults

3. Restart/Reboot SSH Server

• For Ubuntu 14.04 and below version

    sudo restart ssh

• For Ubuntu 15.04 and above version

    sudo systemctl restart ssh

Now you will be able to connect to ubuntu using any ssh client application like PuTTY, Bitvise, winscp etc. Just follow below steps.

• Check ip details using ifconfig command.
• Use inet addr address and login to ssh client using user and password.