top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Under what conditions should indexes be used?

0 votes
426 views
Under what conditions should indexes be used?
posted Aug 24, 2014 by Vrije Mani Upadhyay

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

When a small number of rows (“small” is version and hardware dependent) are returned to meet a condition in a query, you generally want to use an index on that condition (column), given that the small number of rows also returns a small number of individual blocks (usually the case).

answer Sep 12, 2014 by Archana
Similar Questions
+3 votes
What could be the Algorithm/s in database backup/s and restore programs ?. i.e. C/C++ Programming logic/Algorithm.

http://en.wikipedia.org/wiki/Relational_database_management_system

There are Database Backup and restore utilities for RDBMS Systems.
The Backup program generates a (.Bak) Binary File as output which can later be restored in case the Database crashes.

What could be the Algorithm/s in database backup/s and restore programs ?. i.e. C/C++ Programming logic/Algorithm.

0 votes
LTE: What all MCS indexes can be used for the configuration of PMCH ?

Many values for the MCS index have been defined in the specification. Value ranges from 0 to 31.
Each MCS index values corresponds to different combination of "number of spatial streams + modulation type + Coding rate" .
In case of PDSCH resource allocation, eNodeB considers feedback from the UE but in case of PMCH where data is transmitted only at downlink. How a particular MCS index would be chosen for multimedia multicast broadcast data transmission ?
If I am correct, selection of MCS index is done at MCE and sends to eNodeBs/cells belong to the same MBSFN area ?
In this case when MCS index is selected by MCE, how MCE take decision on this factor ?
I am also looking for set of MCS index values which can be used for MBMS transmission ?

...