Welcome -
Guest!
Login
/
Register Now
|
Search:
Home
Articles
Forum
Interview FAQ
Activities
News
Videos
Poll
Links
People
Groups
SQL FAQ
Submit Interview FAQ
Home
»
Interview FAQ
»
SQL
RSS Feeds
Should tables and their corresponding indexes reside on the same disk?
Shared By:
Shruti Sharma
Date:
Dec 21
Category:
SQL
Views:
648
Answer:
Absolutely not. If possible, always store tables and indexes separately to avoid disk contention.
Share:
Previous Post:
What does streamline an SQL statement mean?
Next Post:
Why is the arrangement of conditions in an SQL statement important?
Didn't find what you were looking for? Find more on
Should tables and their corresponding indexes reside on the same disk?
Or get
search suggestion and latest updates
.
Related Topics:
What do you understand by indexing in Access?
If you own a table, who can select from that table?
What would happen if you created a table and granted select privileges on the table to public?
If you have a trigger on a table and the table is dropped, does the trigger still exist?
How can you avoid a full-table scan?
What happens during a full-table scan?
Distinguish between Select query and Action Query, Database and Table, Filter and Query etc
Using today's TEAMSTATS table, write a query to determine who is batting under .25
Using the CHECKS table, write a query to return all the unique remarks
Dual table in oracle
Provide syntax to truncate a table
Provide syntax to rename a table
How to insert records into tables?
How to create table?
What is semi-random or indexed sequential file organizations in dfs (data file structure)?
What is an Index file in dfs (data file structure)?
What will happen if a unique index is created on a nonunique field?
In Oracle, how can you find out what tables and views you own?
What does the # in front of a temporary table signify?
Using the CHECKS table from earlier today, write a query to return just the check numbers and t
Your Comment
*
*
Comment should be atleast 30 Characters.
Please put code inside [Code] your code [/Code].
Please login to post comment
Tagged:
should
tables
and
their
corresponding
indexes
reside
on
the
same
disk
Assembly Language
Artificial Intelligence
C Programming
C++ Programming
Visual C++
OOAD
Cobol
Java
SQL Server
Asp.net MVC
Rest and WCF Services
Entity Framework
Knockout.Js
Unix / Linux / Ubuntu
Networking
OOPs Concept
HTML
Dos
SQL
System Analysis & Design
Gadgets
Internet
CSS
Javascript
.Net Framework
Asp.net
C#
VB.Net
Python
Perl
Oracle
Software Engineering
RDBMS Terms
AJAX Framework
Design Pattern
UML
WPF
WCF
SEO
PowerShell
Visual Studio
WWF
BizTalk Server
Azure
General
Testing
Online Certifications
PHP
My SQL
LinQ
Project Management
Silverlight
XML
MS Office
Windows OS
DHTML
Sharepoint