Who decides to allocate indexes onto pages? Storage Engine Or Query Processor?

Question

Post reply

Who decides to allocate indexes onto pages? Storage Engine Or Query Processor?

Thinky Night

SSCommitted

Points: 1663
More actions
November 6, 2014 at 7:22 am

#292358

Hi All,
Through the SQL Server, Let me know, How Indexes are allocates on pages? And If a CREATE INDEX Statement Executed on a query Window, Query processor meets and executes these query. However it was meet, who decides to separate indexes onto pages? Storage Engine or Query Processor(Query Optimizer)? Does it work like UPDATE-Statements in Query Optimizer?
Best Regards,

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

The Quey Processor parses the statement (which is DDL, not DML) and then executes it.

Storing index data into pages is not a "decision": all b-tree indexes are stored in pages.

The Storage Engine takes care of the allocation of the extents to accomodate the index pages.

Hope this helps

-- Gianluca Sartori

Thinky Night SSCommitted Points: 1663 More actions · Answer 2

So, Do i say that; Storage Engine acts with an operating system's intelligence? And does not it have decision making pleasure?

Have i understood closely?

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

Thinky Night (11/6/2014)
So, Do i say that; Storage Engine acts with an operating system's intelligence? And does not it have decision making pleasure?
Have i understood closely?

I wouldn't say that.

I'm just saying that organizing indexes in pages is not a decision, because all b-tree indexes are organized in pages.

-- Gianluca Sartori

Thinky Night SSCommitted Points: 1663 More actions · Answer 4

Just i meant, who tells that separation onto pages with a B-TREE Data Structure? Storage Engine or Query Processor.

But Thanks a lot, I understood this framework. 🙂