SYSTEM, METHOD, AND DEVICE FOR INDEX COMPILATION TO OPTIMIZE INDEX USAGE

摘要

System, method, and device for index compilation to optimize index are disclosed. Once a CREATE INDEX command is fired, the method first checks if the user has requested to compile this index, if yes then generates corresponding C-file and then generates DLL out of the C-file and loads the DLL with server. The System, method, and device natively compile and generate an INDEX DLL corresponding to each INDEX during definition, which will contain all required structure and method to perform on INDEX based on the indexed column data-type.