Difference between Single-Level and Multi-level Partitioning

Answered

By: Sushma | 21 Aug 2014 6:40 pm | 1 Comments

Hello All,

What is single-level and multi-level partitioning?

Please provide the Solution.

Comments

rekha |

| 21 Aug 2014 1:16 pm

Helpful answer

If a table is partitioned exclusively by one of the above partitioning approaches (HASH, ROUNDROBIN, RANGE), it is called single-level partitioning.

If each of the partitions itself is partitioned again by other criteria, we call it multi-level partitioning.

Different types of Partitioning supported by SAP HANA
What are the different types of partitioning supported by SAP HANA ? There are two types of partitioning supported by SAP HANA1.Single-Level Partitioning.Rows can be distributed to partitions...
Differences between SAP HANA and Oracle
SAP HANA vs. OracleListed below are some of the basic differences between Oracle and SAP HANA:tttttttttNametttttttttOracletttttttttSAP...
Difference between SAP HANA and Hadoop
SAP HANA vs HadoopListed below are some of the major differences between SAP HANA and Hadoop, although both HANA and Hadoop are equally competitive, useful and offers the best to their customers...
Oracle Partitioning Interview Questions and Answers
FAQ: Oracle partitioning 1. What is partitioning?Partitioning is the process of separating data into logical subsets. In the same way as normal tables and indexes, partitions are physical...

Forums

Books

Jobs

SAP S4 HANA Implementation Opportunity!!!
Exp :4 - 30 years | City : Chennai
SAP Project manager openings@ Delhi/ Mumbai
Exp :10 - 26 years | City : Delhi
ABAP HANA Consultant Job | 5 - 8 yrs | Bengaluru | SAP India
Exp :3 - 5 years | City : Bangalore
Opening for Sr. SAP Basis Consultant @ Bangalore (Immediate
Exp :6 - 15 years | City : Bangalore
SAP Hana Cloud Integeration | 6 - 9 Years | Pune | Atos
Exp :6 - 9 years | City : Pune

ASK US !

Get solutions from our experts!

A&D (Aerospace & Defense)
ABAP
About SAP
Android
Announcement of Legal Change
APO (Advanced Planner and Optimizer)
Audit Management
BASIS
BCM (Business Communication Management)
BI (Business Intelligence)
BI Suite - Business Explorer
BO (Business Objects)
BODS (Business Objects Data Services)
BOPF (Business Object Processing Framework)
BPC (Business Planning and Consolidation)
BPM (Business Process Management)
Business ByDesign
Business One
Business Suite
BW (Business Warehousing)
C++
CLM (Contract Lifecycle Management)
Cloud
CRM (Customer Relationship Management)
CS (Customer Service)
Do It Yourself
DSiM (Demand Signal Management)
E-Recruitment
EAM (Enterprise Asset Management)
EC (Enterprise Controlling)
EHS ( Environment, Health, and Safety Management )
EP (Enterprise Portal)
ERP (Enterprise Resource Planning)
Event Management
EWM (Extended Warehouse Management)
FICO (Financial Accounting and Controlling)
FIN-FSCM (Financial Supply Chain Management)
Fiori
FS-BA (Bank Analyzer)
FS-CD (Collections and Disbursements)
GRC (Governance Risk Compliance)
GST (Goods And Service Tax)
GTS (Global Trade Services)
GUI (Graphical User Interface)
GWM (Gateway for Microsoft)
HANA
HCM (HCM Human Capital Management)
HR (Human Resource)
Hybris (SAP E-Commerce Software)
IdM (Identity Management)
IFRS (International Financial Reporting Standards)
IM (Investment Management)
Integration Server
IS (Industry Solutions)
IT Management
Java
KW (Knowledge Warehouse)
Landscape Transformation of Replication Server
Lightroom
Logistics Information System
Lumira
MaxDB
MDM (Master Data Management)
ME (Manufacturing Execution)
MM (Materials Management)
Mobile
MRS (Multi Resource Scheduling)
MySAP
MySQL
NetWeaver
OCM (Order Change Management)
OM (Organisational Management)
Oracle
Oracle SQL
PE (Product Enhancement)
Photoshop
PHP
PI (Process Integration)
PLM (Product Lifecycle Management)
PM (Plant Maintenance)
PO (Process Orchestration)
Point-of-Sale (POS) Data Management (DM)
Postalsoft
PP (Production Planning)
PPM (Portfolio and Project Management)
Predictive Analytics
Project Manager
PS (Project Systems)
Python
QA (Quality Assurance)
QM (Quality Management)
SAP Office
SCM (Supply Chain Management)
SD (Sales and Distribution)
SEM (Strategic Enterprise Management Software)
SEO (Search Engine Optimization)
Shared Service Framework
SOD (Segregation of Duties)
Solution Manager
SQL
SRM (Supplier Relationship Management)
SSO (Single Sign-On)
TAO (Test Acceleration and Optimization)
TDMS (Test Data Migration Server )
Telecommunications
Third Party
TM (Travel Management)
TR (Treasury)
UI5
UNIX
User Experience (UX)
Warranty Management
WEB DYNPRO
Web IDE
Windows
WMS (Warehouse Management System)
XI (Exchange Infrastructure)