Contents
What is a high selectivity index?
The selectivity index (SI) is a ratio that measures the window between cytotoxicity and antiviral activity by dividing the given AVA value into the TOX value (AVA/TOX). The higher the SI ratio, the theoretically more effective and safe a drug would be during in vivo treatment for a given viral infection.
Does index should be unique?
Unique indexes are indexes that help maintain data integrity by ensuring that no two rows of data in a table have identical key values. When you create a unique index for an existing table with data, values in the columns or expressions that comprise the index key are checked for uniqueness.
What rules are followed for index selection?
At least three possibilities: 1) Record of key (only primary index) 2) Key and pointer to record of key. 3) Key and list of pointers to the records containing the key (for non-unique keys).
Should CC50 be high or low?
In the Ideal situation you want to have your IC50 concentration below your CC50 concentration and your CC50 and MNTD as high as possible.
Does selectivity indicate safety?
Selectivity is an important attribute of effective and safe drugs, and prediction of in vivo target and tissue selectivity would likely improve drug development success rates.
Which is the ideal selectivity of an index?
The ratio of the number of distinct values in the indexed column / columns to the number of records in the table represents the selectivity of an index. The ideal selectivity is 1. Such a selectivity can be reached only by unique indexes on NOT NULL columns.
How big can a selective XML index be?
The primary key of the user table is limited to a size of 128 bytes when used with selective XML indexes. The clustering key of the user table is limited to 15 columns when used with selective XML indexes. Each selective XML index can only be created on a single XML column. You cannot create a selective XML index on a non-XML column.
How big does a clustered index need to be?
A clustered index must exist on the primary key of the user table. The primary key of the user table is limited to a size of 128 bytes when used with selective XML indexes. The clustering key of the user table is limited to 15 columns when used with selective XML indexes.
When does an index seek do more harm than good?
If a column has low selectivity, an index seek does more harm that good. But none of the articles explain why. Can anybody explain why it is so, or provide a link to a relevant article? The ratio of unique values within a key column is referred to as index selectivity.