| |

VerySource

 Forgot password?
 Register
Search
View: 882|Reply: 3

× Focus index and non-focus index

[Copy link]

1

Threads

3

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

Post time: 2020-3-11 21:30:01
| Show all posts |Read mode
Let's talk
When will you build a focused index?
When is an unfocused index suitable?
Reply

Use magic Report

0

Threads

114

Posts

69.00

Credits

Newbie

Rank: 1

Credits
69.00

 China

Post time: 2020-6-4 21:45:02
| Show all posts
See online help~
Reply

Use magic Report

0

Threads

126

Posts

73.00

Credits

Newbie

Rank: 1

Credits
73.00

 China

Post time: 2020-6-5 14:00:01
| Show all posts
Clustered index
When creating a clustered index on a table (heap) or deleting and recreating an existing clustered index, the database is required to have an additional available work area to accommodate the data sorting results and temporary copies of the original table or existing clustered index data.
Reply

Use magic Report

0

Threads

28

Posts

25.00

Credits

Newbie

Rank: 1

Credits
25.00

 China

Post time: 2020-6-6 01:45:01
| Show all posts
The primary key will automatically create a focused index by default
Focused index There is only one table, so it is very valuable.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list