1

Topic: Whether has sense clustered index after TRUNCATE tables?

Good afternoon.
Prompt please.
Whether gives  after  any gain in speed of requests to the table?
sp_spaceused Shows that right after  the size of an index becomes 8.

2

Re: Whether has sense clustered index after TRUNCATE tables?

Goats Nikolay;
o-o Your client smile

3

Re: Whether has sense clustered index after TRUNCATE tables?

Not , Goats, write safely requests to the empty table.
By speed of obtaining of result will be pleasantly surprised.
Note, without everyones

4

Re: Whether has sense clustered index after TRUNCATE tables?

o-o wrote:

not , Goats, write safely requests to the empty table.
By speed of obtaining of result will be pleasantly surprised.
Note, without everyones

The table is filled with a velocity of light.
Whether there will be a difference in

update..... where id=xxx

After a pair of clocks after:
1) Truncate
2) Truncate + Rebuild
?

5

Re: Whether has sense clustered index after TRUNCATE tables?

And water in a mortar  not a variant?
Right after TRUNCATE.
To feel a difference through p hours

6

Re: Whether has sense clustered index after TRUNCATE tables?

Goats Nikolay;

wrote:

the Table is filled with a velocity of light.

And as km/s correlate with iops

7

Re: Whether has sense clustered index after TRUNCATE tables?

TaPaK wrote:

Goats Nikolay;
it is passed...
And as km/s correlate with iops

It was the metaphor.

8

Re: Whether has sense clustered index after TRUNCATE tables?

Nikolay wrote:

sp_spaceused Shows that right after  the size of an index becomes 8 .

For skillful use whois I will help smile
There is no practical sense  a 1-page index

9

Re: Whether has sense clustered index after TRUNCATE tables?

komrad wrote:

it is passed...
For skillful use whois I will help smile
There is no practical sense  a 1-page index

Understood, thanks!