Group Discounts available for 3+ students and Corporate Clients

Data distribution in other RDBMS

 

Data distribution in other RDBMS

It is sequential so, storing and retrieve take  time So that take lot of time storing and retrieval

 

Data distribution in tera data

  1. a) Automatic A sit is automatic, it loads any volume of data
  2. b) uniform(or) even(or)randomly It loads the data uniformly or parallel so that distribution and retrieval faster.

This automatic and uniform event is possibly in tera data, because of indexes.

 

Data Access Mechanism

  1. a) Full table scan (FTS)
  2. b) Primary index retrieval (P.I)
  3. c) Secondary index retrieval(S.I)

 

A) FULL TABLE SCAN(FTS)

 

Screenshot_51

 

i) System performance

In case of FTS System performance decreased

 

ii) Situation to Get

a) If the indexed columns are not used in the query

b) An index is used in non-equal to test

c) Range of value specified in primary index

 

Ex:-

b)Sel*from party where party name like’V%’

  1. C) Sel* from party where party income between 5000 and 7000 

 

FTS Process

  1. i) It scans every data block in table
  2. ii) All Amp scan for the table portion

 

Remedy

Take appropriate PI to avoid FTS

To Apply PI to avoid FTS

To used PI to avoid FTS.

 

 

 

 

 

 

 

 

 

 

 

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Data distribution in other RDBMS"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please Enter Your Details and Query.
    Three + 6