Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  Buy Now
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

Query Optimization in HxTT
2006-01-03 00:00:00.0
I am testing HxTT JDBC drivers for my university project. I tested the programms which came with demo package. Can anyone please explain the importance of programm and also I need to know how a complicated query is optimized in HxTT JDBC driver

I would highly appreciate if you can solve my question


Happy New Year

Re:Query Optimization in HxTT
HXTT Support
2006-01-03 00:00:00.0
>Can anyone please explain the importance of programm
testSQL is only used to show how to use JDBC api to execute some sqls. If you have Java and JDBC experience, you can skip that sample and use DBVisualizer, iSQL-Viewer, JBuilder's Database Pilot, SQuirreL SQL Client, DbEdit Database Utilites, and so on, to operate your data in GUI.

>I need to know how a complicated query is optimized in HxTT JDBC driver
HXTT sql parser will analyze your sql, and do many optimizations according to existent index or temporary index. For instance, it will adjust the table order of join tables, and transform your where clause, having clause, and join condition. Some where clause will be calculated as constant, some OR conditions will become IN operation(a=3 or a=4 become a in (3,4)), some AND conditions will become a condition (a=3 and b=4 become (a,b)=(3,4), a=3 and b>'abc' become (a,b)(=,>)(3,4)) to utilize compound index. All in, between.. and... can utilize index. a like 'eeee' will become a='eee', and a like 'a%' can utilize index. Sometimes it will utilize bitmap operation for condition operation. A prepared sql can be optimizsed too...

Search Key   Search by Last 50 Questions


Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap