The above statement will run the query with 8 degree of parallelism. SELECT /*+ parallel(employees,8) */ employee_id, Employee_name FROM hr.employees SELECT /*+ parallel(table_name,degree_of_parallelism) */ column_1, column_2,column.n FROM Table_name
Example : Select /*+ parallel (emp,16) */ from Employee emp Alter table Employee parallel degree 15 4.Use of Parallel Hint : You can directly use the parallel hint to run query in parallel sessions. Example : If you want to run employee table data fast you can use following query. Example : Alter session force parallel query 3.Object Level parallelism : You can apply parallelism at object level. 2.Session Level : If you have requirement where you need to run queries fast at session level then you can apply this parallelism concept. Make sure that you are not using this parallelism in Online Transactional Processing ( OLTP).
System Level Parallelism : This technique is mainly used in DWH. There are following 4 types of degree of parallelism which you may use in Oracle SQL but with this hint we are using SQL statement level parallelism : 1.
#Mysql optimizer hint full
The parallel hint is used to create the multiple parallel sessions so that the load will be divided properly within sever at the time of execution. In this article I would like to give you the details and example of the most common link which is used to improve the performance of SQL – parallel hint with examples. In this article I would like to give the SQL performance technique to use the hints in SQL. In my previous articles I have already given the details about the SQL performance tuning with examples.
0 kommentar(er)
