This tag pertains to performance issues with Structured Query Language (SQL): performance bottlenecks faced when managing data in relational database management systems.
Given the next SQL statement: Select * from A join B on A.id1=B.id1 and A.id2=B.id2 …
sql oracle11g sqlperformanceIs it more efficient to execute one UPDATE statement with multiple columns UPDATE myTable SET [col1] = [col1] + 1, [col2] = [col2] + 1, [col3] = […
sql sql-server performance sqlperformanceThis is a simple question. Suppose I have a massive table (5 million rows), and I have no option but to …
database oracle sqlperformance full-table-scanOne of my columns can only contain 4 possible values (val1, val2, val3, val4). I need to add an additional filter …
sql tsql sqlperformance notin sql-inCould anyone advice on how do I improve the performance of the following query. Note, the problem seems to be …
sql sql-server sql-server-2008 self-join sqlperformanceI know of two different ways to select a single row from a table (without a where clause that guarantees …
sql sql-server performance query-performance sqlperformanceI have a web application that use a SQL Server database that is shared with others web applications (over which …
sql-server triggers polling sqldependency sqlperformanceWe have a database currently sitting on 15000 RPM drives that is simply a logging database and we want to move …
sql sql-server-2005 sqlperformanceI Use Mysql 5.5.. + INNODB and windows server. The case(make it simple then real case): I have 2 tables 1GB with …
mysql sql performance database-performance sqlperformance