Book
SQL Server Execution Plans
| Identifier | --grantfritc-1642 |
|---|---|
| Penulis / Pengarang | Grant Fritchey |
| Kata Kunci | SQL Server Databases |
| Tanggal Publikasi | 24 Apr 2018 |
| Bahasa | Bahasa Inggris |
| Abstrak / Deskripsi | An execution plan is a set of instructions for executing a query. Devised by the SQL Server Query Optimizer, an execution plan describes the set of operations that the execution engine needs to perform to return the data required by a query. The execution plan is your window into the SQL Server Query Optimizer and query execution engine. It will reveal which tables and indexes a query accessed, in which order, how they were accessed, what types of joins were used, how much data was retrieved initially, and at what point filtering and sorting occurred. It will show how aggregations were performed, how calculated columns were derived, how and where foreign keys were accessed, and more. |
| Hak Cipta | All rights reserved. No part of this publication may be reproduced, stored, or introduced into a retrieval system, or transmitted, in any form, or by any means (electronic, mechanical, photocopying, recording, or otherwise) without the prior written consent of the publisher. Any person who does any unauthorized act in relation to this publication may be liable to criminal prosecution and civil claims for damages. |
File Lampiran / Download (1)
| No | Nama Berkas | Format | Ukuran | Aksi |
|---|---|---|---|---|
| 1 | sql-server-execution-plans-3rd-edition.pdf | application/pdf | 23,6 MB | ⬇️ Buka / Download |
Komentar & Diskusi (0)
Belum ada komentar untuk koleksi ini. Jadilah yang pertama berdiskusi!