3/31/2024 0 Comments Parallel query processing in dbmsParallel processing can help improve performance in situations where large amounts of data need to be examined or processed, such as scanning or joining large tables, creating large indexes, or scanning partitioned indexes. Here, query (data) is handled by one resource process in the database with a single request. Each process looks at only a portion of the total data for the request. Using parallel processing, the request is broken down into multiple units to be worked on by multiple database processes. Using normal (that is, serial) processing, the data involved in a single request (for example, user query) is handled by one database process. One of the best and easiest ways to boost performance is to take advantage of the parallel processing option offered by the Oracle Database 12c. Improving performance (and by this, we usually mean query performance) is always a hot item with database administrators and users. Parallel processing in Oracle Database 12c
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |