Stack Overflow
Stack Overflow

Questions tagged [database-tuning]

deals with optimizing the performance of a database. It can be about file design, and selection of the DBMS, OS and platform.

Database tuning is about maximizing the performance of a database. It can include hardware, software, file system, OS and DBMS selection. See the wikipedia article for more.

158 questions
2
votes
2 answers

How to find out which tables are most accessed or frequently used in Oracle 10g

I am facing trouble in getting the most frequently used tables in oracle 10g. I'm using Oracle 10g version 10.2.0.4.0 with EBS R12.1.3 Application on it. Please help me in sorting out the most frequently used table in my DataBase. If possible I…
ARGStackOvaFlo
  • 185
  • 1
  • 4
  • 16
2
votes
1 answer

Oracle index containing all columns of another index, right or wrong

I am working on an Oracle 12c database. I have a table being queried a lot. One query uses columns A and B in where clause, another query uses A,B,C,D & E columns in the where clause. I want to speed up queries. I have added 2 non-unique indexes,…
Mahdi Tahsildari
  • 13,065
  • 14
  • 55
  • 94
2
votes
1 answer

Neo4j Cypher Query Tuning

I'd like to provide the same level of query tuning support in Neo4j that I provide for relational databases. I understand that many tuning problems are best solved through data design, but sometimes you just need to help the optimizer along. There's…
Michael Dunkin
  • 51
  • 2
2
votes
0 answers

Optimizing sequential scan in PostgreSQL

PostgreSQL 9.4 In the article about hardware optimization for PostgreSQL server was shown that too much moving disk head may cause performance bottleneck. As far as I got, for the sequential scan, it'd be much faster if the cylinders with blocks of…
St.Antario
  • 26,175
  • 41
  • 130
  • 318
2
votes
2 answers

Do gaps in the Identity (primary key clustered) table affects performance of database?

Alright here comes the million dollar question Assume that i have the following table SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tblUsersProfile]( [personId] [int] IDENTITY(1,1) NOT NULL, …
Furkan Gözükara
  • 22,964
  • 77
  • 205
  • 342
2
votes
1 answer

Stats in v$sqlarea over time gets lower

I wrote an application that queries oracle v$sqlarea and dumps data to my own database for further analysis. I noticed something very strange - sometimes data in the v$sqlarea shows less executions than before. I'm pretty sure that the oracle cache…
Nadir
  • 1,369
  • 1
  • 15
  • 28
2
votes
0 answers

make postgres use more memory

We have a dedicated DB server running Ubuntu 14.04 with 8 cores, 16GB of Memory and and 3TB HD. Postgres is version 9.4. I have one batch job running that crawls through a lot of data (combining geo-points into lines). The data is stored in…
pat
  • 2,600
  • 4
  • 20
  • 21
2
votes
1 answer

I have a SQL script

I have a SQL script that looks like this: Variable nb number; Variable var1 varchar2(30); Variable var2 varchar2(30); EXEC :var1 := '&1'; EXEC :var2 := '&2'; BEGIN SELECT count(*) into :nb FROM some_table where col1=:var1 and…
Rohit
  • 371
  • 4
  • 18
2
votes
1 answer

Check if the nullable column is sparsed or not query in SQL Server

How to check if a column has been set as Sparse or not? I know how to add the sparse while creating or altering tables ALTER TABLE T1 ALTER COLUMN C1 VARCHAR(50) SPARSE NULL GO And it is possible to execute sparse query for the sparsed column. But…
MJK
  • 3,434
  • 3
  • 32
  • 55
2
votes
0 answers

MS sql 2012 Tuning process exited unexpectedly. DTAEngine

I am using Windows Server 2012, Ms SQL 2012. I am running Database tuning advisor and the settings : advisor plan cache. Database workload master. Check my database all the tables. When tool is started after few seconds i ma getting : MS sql 2012…
kostas ch.
  • 1,960
  • 1
  • 17
  • 30
2
votes
2 answers

How to get memory size used for a query in mysql?

THe reason I am asking this question is that I want to make sure if some of my queries will use more memory than that of query_cache_limit. Some people suggusted using 'show table status like 'table_name'. I think it is not relevant to this…
user1342336
  • 967
  • 2
  • 16
  • 28
2
votes
3 answers

What is the difference between database tuning and database query optimization?

Can someone provide me the exact difference between Database Tuning and Database Query Optimization? I have read the following links on Wikipedia: http://en.wikipedia.org/wiki/Query_optimization http://en.wikipedia.org/wiki/Database_tuning As per my…
Abhishek Aggarwal
  • 355
  • 3
  • 13
1
vote
1 answer

Does Automatic tuning in Azure SQL Database reorganize and rebuild indexes?

We are looking into turing on Automatic tuning in Azure SQL Database (https://learn.microsoft.com/en-gb/azure/azure-sql/database/automatic-tuning-overview?view=azuresql) and use all 3 available options. Does the create index option reorganise or…
user1329339
  • 1,295
  • 1
  • 11
  • 26
1
vote
2 answers

How to see, what's *really* going on in a query execution?

In SQL Server 2008, I would like to examine what is really going on behind the scenes when a query is executed. Can I somehow see the following? The number of (and maybe even the content of) the log records "produced" by a query. When the contents…
someName
  • 1,275
  • 2
  • 14
  • 33
1
vote
1 answer

Need suggestion for POSTGRES Tuning

I am in a need to run the few complicated queries frequently on my database, one of my queries is taking around 57 sec to execute, I am trying a way to tune my Postgres database, so, I can cut the execution time to half or more than that. I have…
Sujeet Chaurasia
  • 97
  • 8
1 2
3
…
10 11