Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Describe important index characteristics?



Describe important index characteristics?..

Answer / Prabhakar Awasthi

Important Index Characteristics include: 1) Unique: The indexed column should be unique or almost unique to reduce the number of records that need to be searched. 2) Narrow: The indexed column(s) should be as short as possible to minimize the storage space required for the index. 3) Frequently Used: The indexed column(s) should be frequently used in WHERE, ORDER BY, or JOIN clauses to improve query performance.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Mining Interview Questions

Define pre pruning?

1 Answers  


Name methods of clustering?

1 Answers  


What do you mean by partitioning method?

1 Answers  


What do you mean by Data mining?

1 Answers   TCS,


What is model based method?

1 Answers  


Explain what is discrete and continuous data in data mining world?

1 Answers  


Why is data mining hot cake topic for this generation?

1 Answers  


Explain the density-based method?

1 Answers  


Define rollup and cube?

1 Answers  


What does subject-oriented data warehouse signify?

1 Answers  


Give a brief introduction to data mining knowledge discovery?

1 Answers  


What is cure?

1 Answers  


Categories
  • AI Algorithms Interview Questions AI Algorithms (74)
  • AI Natural Language Processing Interview Questions AI Natural Language Processing (96)
  • AI Knowledge Representation Reasoning Interview Questions AI Knowledge Representation Reasoning (12)
  • AI Robotics Interview Questions AI Robotics (183)
  • AI Computer Vision Interview Questions AI Computer Vision (13)
  • AI Neural Networks Interview Questions AI Neural Networks (66)
  • AI Fuzzy Logic Interview Questions AI Fuzzy Logic (31)
  • AI Games Interview Questions AI Games (8)
  • AI Languages Interview Questions AI Languages (141)
  • AI Tools Interview Questions AI Tools (11)
  • AI Machine Learning Interview Questions AI Machine Learning (659)
  • Data Science Interview Questions Data Science (671)
  • Data Mining Interview Questions Data Mining (120)
  • AI Deep Learning Interview Questions AI Deep Learning (111)
  • Generative AI Interview Questions Generative AI (153)
  • AI Frameworks Libraries Interview Questions AI Frameworks Libraries (197)
  • AI Ethics Safety Interview Questions AI Ethics Safety (100)
  • AI Applications Interview Questions AI Applications (427)
  • AI General Interview Questions AI General (197)
  • AI AllOther Interview Questions AI AllOther (6)