You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
- 0 Answers
- 738 Views
- I also Faced
- E-Mail Answers
Tell me what is difference between view and materialized view?
Tell me the difference between clustered and non-clustered index?
What happens if null values are involved in boolean operations?
What is use of except clause? How it differs from not in clause?
Explain indexes disadvantages?
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
what are candidate key, alternate key and composite key? : Sql server database administration
Tell me what are the advantages of using stored procedures?
explain the type of contraints
Explain steps of normalization?
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
