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.

Do deattached indexes take up more space?

April 26, 2017indexes

0

10 Posted

Do deattached indexes take up more space?

1 Answer

0

10 Posted

On 18th Feb 1998 mcollins@us.dhl.com (Mark Collins) wrote:- Detached indexes actually take more space. In an attached index, each key includes a one-byte delete flag and a four-byte row location. With a detached index, you also have a four-byte tablespace identifier that points to the base table’s tablespace. This can be verified by running oncheck against an attached index vs. a detached index.