Обсуждение: create index does change pages?

Поиск
Список
Период
Сортировка

create index does change pages?

От
mohsen soodkhah mohammadi
Дата:
hello.
dose one create index on the large table changes the place of some tuples in some pages?

Re: create index does change pages?

От
Heikki Linnakangas
Дата:
On 20.07.2013 12:56, mohsen soodkhah mohammadi wrote:
> hello.
> dose one create index on the large table changes the place of some tuples
> in some pages?

No, creating an index doesn't move any tuples in the heap.

- Heikki



Re: create index does change pages?

От
Atri Sharma
Дата:

Sent from my iPad

On 20-Jul-2013, at 15:26, mohsen soodkhah mohammadi <mohsensoodkhah@gmail.com> wrote:

> hello.
> dose one create index on the large table changes the place of some tuples in some pages?


No, making an index involves keeping some metadata about your tables in an auxiliary data structure. It will require
someextra memory for the auxiliary data structure, but there is no moving of the actual tuples. 

Regards,

Atri