PARTITION ACCESS METHOD FOR QUERY OPTIMIZATION

    公开(公告)号:US20180196849A1

    公开(公告)日:2018-07-12

    申请号:US15937976

    申请日:2018-03-28

    IPC分类号: G06F17/30

    摘要: In an approach to determining an access method for a partition in a partition table, a computer receives a query and determines if there is a partition table utilized by the query. When there is a partition table utilized by the query, then the computer determines that a partition in the partition table meets the plurality of conditions of the query. The computer collects a plurality of partition level statistics for the partition that meets the plurality of conditions of the query. Additionally, the computer determines, based, at least in part, on the plurality of partition level statistics, a cost for one or more access methods for the partition that meets the plurality of conditions of the query. Furthermore, the computer determines, based, at least in part, on the cost for each access method, an access method for the partition that meets the plurality of conditions of the query.

    Apparatus and methods for making azimuthal resistivity measurements

    公开(公告)号:US09952347B2

    公开(公告)日:2018-04-24

    申请号:US15696543

    申请日:2017-09-06

    发明人: Tsili Wang

    摘要: A resistivity measuring tool used in a drillstring having a drill bit on a distal end for drilling a wellbore in a formation includes a tool body having a longitudinal axis, a sensor configured to measure the angular position of the tool body relative to the wellbore, at least one axial antenna including a wire winding for generating an axial magnetic moment parallel with the longitudinal axis, and at least one transverse antenna. The transverse antenna includes an antenna body disposed within a pocket extending radially inward from an outer surface of the tool body and one or more turns of wire wound around the antenna body, the wire winding generating a transverse magnetic moment orthogonal to the longitudinal axis.