dbTalk Databases Forums  

CNF and DNF SQL queries

comp.databases comp.databases


Discuss CNF and DNF SQL queries in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tsukrov Stanislav
 
Posts: n/a

Default CNF and DNF SQL queries - 07-07-2003 , 12:17 PM






I am writing an ODBC driver and a small SQL-Engine for a datasource of
my firm.
ODBC tools use a lot of DNF queries like

SELECT ...
WHERE
PK1=? AND PK2=?
OR
PK1=? AND PK2=?
OR
PK1=? AND PK2=?
OR
....

MS Access builds also DNF-queries. Where can I find a description of
possible SQL query-optimezer, that can handle such queries without
converting them to CNF. How it's done in PostgreSQL 7.x? I've found,
that PQ 6.x have used CNF with some special optimizations for keyset
queries. Where can I find it?

Thanks

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.