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);

Performance Engineering

Performance engineering or SPE (Systems Performance Engineering or Software Performance Engineering) within systems engineering, encompasses the set of roles, skills, activities, practices, tools, and deliverable applied at every phase of the systems development life cycle which ensures that a solution will be designed, implemented, and operationally supported to meet the non-functional requirements for performance (such as throughput, latency, or memory usage).

It may be alternatively referred to as software performance engineering or application performance engineering within software engineering. As the connection between application success and business success continues to gain recognition, particularly in the mobile space, application performance engineering has taken on a preventative and perfective role within the software development life cycle. As such, the term is typically used to describe the processes, people and technologies required to effectively test non-functional requirements, ensure adherence to service levels and optimize application performance prior to deployment.

The term performance engineering encompasses more than just the software and supporting infrastructure, and as such the term performance engineering is preferable from a macro view. Adherence to the non-functional requirements is also validated post-deployment by monitoring the production systems. This is part of IT service management.

Performance engineering has become a separate discipline at a number of large corporations, with tasking separate but parallel to Systems Engineering. It is pervasive, involving people from multiple organizational units; but predominantly within the information technology organization.