Question
Explain the concept of fragment elimination in informix ?
Answers
Fragment elimination appears when the following conditions are all satisfied:
A table is fragmented
The fragmentation formula doesn’t create overlapping ? asta oricum nu e permis (overlapping)
A query uses equality filter on a column used in the fragmentation formula
If the above conditions are met, the Informix engine can skip fragments (data is not searched there) that don’t comply with the query filter

    Your Comment




  • Contributors: *,
More Software,Concept Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q What continent is subjected to the world’s largest ozone hole?
  • Q NHB full form:
  • Q Certkiller .com is configuring the serial interface of a Cisco router to connect to the router of a new ISP. A full T1 is being used for the Internet connection. After issuing the show interface serial 0/0 command, it is observed that the interface is UP and the line protocol is DOWN. Which of the following commands could fix this problem? A. Border# copy running-config startup-config B. Border(config)# no shutdown C. Border(config-if)# encapsulation ppp D. Border(config-if)# no cdp enable E. Border(config-if)# ip routing
  • Q In which areas, the “midnight sun” can be seen-
  • Q What is stop band?
  • Q Which band do you like? And why?
  • Q What is new about metasploit support in kali linux?
  • Q Do ahashya da is Navaho for what
  • Q Write a program to find the reverse of a number given.
  • Q Which South African fast bowler and world’s oldest surviving test cricketer passed away recently ?
  • Q Describe the floral formula of Crossosomataceae?