If the application is running very slow? At what points you need to go about the database in order to improve the performance?
No Answer is Posted For this Question
Be the First to Post Answer
Does truncate remove indexes?
What is trigger in pl sql?
Which is faster count (*) or count 1?
how is myisam table stored? : Sql dba
Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.
what is a relationship and what are they? : Sql dba
how do you tune the slow running queries in oracle db , explain the methodology
How to use sql statements in pl/sql?
What is difference between hql and native sql?
Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --
Who developed sql?
Does a join table need a primary key?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)