Interested to Buy Any Domain ? << Click Here >> for more details...
what is the maximum number of indexes i can create for a
table?
What happens if i create indexes for all the columns of a
table? Will it slow down the speed of retrieval
- 2 Answers
- 7826 Views
- I also Faced
- E-Mail Answers
Answer Posted / nawazish sultan
In sql server 2005 we create 250 indexes (1 clustered + 249
non clustered) where as in sql server 2008 it 999.
It is not a best practice to create indexes on all the
columns.Create index on whichever it is necessary becoz it
wont affect too much on DRL but it will obviously slowdown
the DML operation.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to write numeric literals in oracle?
How to define a variable of a specific record type?
What is dual table oracle?
What is a read only transaction in oracle?
How to run create database statement again?
Explain how you would restore a database using RMAN to Point in Time?
How to resolve name conflicts between variables and columns?
How to use like conditions in oracle?
How to create a new table in your schema?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Is it possible to insert comments into sql statements return in the data model editor ?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What are the logical operations?
Can sub procedure/function be called recursively?
What is a data dictionary and how can it be created?
