You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
- 0 Answers
- 477 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to loop through result set objects using odbc_fetch_row()?
How many types of attribute relationships are there? : sql server analysis services, ssas
What is table level trigger?
What is resource governor in sql server?
Which system tables contain information on privileges granted and privileges obtained
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Can you insert NULL in unique column?
Is it possible to create trigger on views?
Can we call stored procedure in view in sql server?
How to insert and update data into a table with "insert" and "update" statements?
What is a data collection table?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
