Back

Explore Courses Blog Tutorials Interview Questions

What is partition in sql?

0 votes
2 views
in SQL by (45k points)

Could someone tell me what is partition in SQL?

1 Answer

0 votes
by (99k points)

Partitioning is a database process which splits very large tables into smaller tables or parts so that queries can now scan data much faster as the fraction of data is reduced from a very large table to a very small part.

Eager to learn SQL and get certified? Then check out SQL certification from Intellipaat!

Do check out our YouTube video to learn more about SQL training.

Related questions

0 votes
1 answer
Oracle “Partition By” Keyword
asked Jul 6, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
What is the difference between PARTITION BY and GROUP BY in SQL server?
asked Mar 31, 2021 in SQL by rahulnayar01123 (6.1k points)
0 votes
1 answer
What is a join in SQL?
asked May 4, 2023 in SQL by neelimakv (32.5k points)
0 votes
1 answer
What is Null Value in SQL?
asked Apr 2, 2021 in SQL by dev_sk2311 (45k points)
0 votes
1 answer
What is the difference between Normalization and Denormalization in SQL?
asked Apr 2, 2021 in SQL by dev_sk2311 (45k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...