Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When creating queries, which keyword will create a sort and incur I/O and processing overhead?

April 26, 2017create creating incur keyword overhead queries sort

0

Posted

When creating queries, which keyword will create a sort and incur I/O and processing overhead?

1 Answer

0

Posted

When DISTINCT is used, the data is sorted. If the statement selects a large number of rows, the server may generate temporary segments to handle the sort runs. This process incurs I/O and processing overhead, and should be avoided.