Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

Good resources for learning database optimization part [closed]

Tags:

sql

database

sql-server

I am good at database(sql) programming part but I want to move ahead into database optimization part like: where and when to indexes, how to decide which query is better than other, how to optimize database. Can you guide me some good resources or books which can lead me to this?

like image

569

asked Nov 01 '10 15:11

Rocky Singh

People also ask

What are the different techniques used for query optimization?

There are two types of query optimization in DBMS: Cost-Based Optimization and Adaptive Query Optimization.

2 Answers

Inside Microsoft SQL Server 2005: Query Tuning and Optimization,

Inside Microsoft SQL Server 2005: T-SQL Querying

Inside Microsoft SQL Server 2005: The Storage Engine

have very deep and thorough explanation of optimizing sql server querying.

like image

188

answered Nov 14 '22 15:11

Giorgi

SQL Server Query Performance Tuning Distilled, Second Edition

like image

20

answered Nov 14 '22 13:11

Otávio Décio

Sign in to Comment

Related questions
                            
                                What is the Future of Linq to SQL
                            
                                What's the best way to manage sql change scripts for two developers?
                            
                                SQL Grouping around gaps
                            
                                Count from a table, but stop counting at a certain number
                            
                                DROP SQL Tables if created date is more than a week - MS SQL Server
                            
                                How do distributed transactions behave with multiple connections to the same DB in a threaded environment?
                            
                                Semantics of the Boolean and comparison operators in the context of three-valued-logic
                            
                                Round-robin assignment
                            
                                oracle sql developer is truncating my results
                            
                                How to change a primary key in SQL to auto_increment?
                            
                                SQL server deadlock between INSERT and SELECT statement
                            
                                Generating incremental numeric column values during INSERT SELECT statement
                            
                                What is the best way to store Binary data (images, pdf's, mp3's, videos ect) in mysql and why?
                            
                                Custom Sort Order - How to not duplicate the Case statement
                            
                                JPA left join to find unused entries
                            
                                How do I preserve data when changing column datatypes in MySQL?
                            
                                MySQL select timestamp as date string
                            
                                len of varbinary
                            
                                MySQL: week date range from week number in a query
                            
                                SQL : ERROR: more than one row returned by a subquery used as an expression

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With