SQL Access Advisor
Oracle Êý¾Ý¿â 10g ÌṩÁË´óÁ¿°ïÖú³ÌÐò£¨»ò“¹ËÎʳÌÐò”£©£¬¿É°ïÖúÄú¾ö¶¨×î¼Ñ²Ù×÷Á÷³Ì¡£ÆäÖÐÒ»¸öʾÀýÊÇ SQL Tuning Advisor£¬Ëü¿ÉÒÔÌṩÓйزéѯµ÷ÕûÒÔ¼°ÔÚÁ÷³ÌÖÐÑÓ³¤Õû¸öÓÅ»¯¹ý³ÌµÄ½¨Òé¡£
µ«Ç뿼ÂÇÒÔϵ÷Õû°¸Àý£º¼ÙÉèÒ»¸öË÷ÒýȷʵÓÐÖúÓÚij¸ö²éѯ£¬µ«¸Ã²éѯִֻÐÐÒ»´Î¡£ÕâÑù£¬¼´Ê¹¸Ã²éѯ¿ÉÒÔµÃÒæÓÚ´ËË÷Òý£¬µ«´´½¨Ë÷ÒýµÄ³É±¾Ò²»á³¬³öÆä´øÀ´µÄºÃ´¦¡£Òª°´ÕâÖÖ·½Ê½·ÖÎö°¸Àý£¬ÄúÐèÒªÁ˽â²éѯµÄ·ÃÎÊƵÂʺÍÔÒò¡£
ÁíÒ»¸ö¹ËÎʳÌÐò (SQL Access Advisor) ¿ÉÖ´ÐÐÕâÖÖÀàÐ͵ķÖÎö¡£³ýÁËÏñÔÚ Oracle Êý¾Ý¿â 10g ÖÐÒ»Ñù¿ÉÒÔ·ÖÎöË÷Òý¡¢ÎﻯÊÓͼµÈ£¬Oracle Êý¾Ý¿â 11g ÖÐµÄ SQL Access Advisor »¹¿ÉÒÔ·ÖÎö±íºÍ²éѯÒÔʶ±ð¿ÉÄܵķÖÇø²ßÂÔ — ÕâÔÚÉè¼Æ×î¼Ñģʽʱ¿ÉÒÔÌṩºÜ´ó°ïÖú¡£ÔÚ Oracle Êý¾Ý¿â 11g ÖУ¬SQL Access Advisor ÏÖÔÚ¿ÉÒÔÌṩÓëÕû¸ö¸ºÔØÏà¹ØµÄ½¨Ò飬°üÀ¨¿¼ÂÇ´´½¨³É±¾ºÍά»¤·ÃÎʽṹ¡£
ÔÚ±¾ÎÄÖУ¬Äú½«Á˽âÐ嵀 SQL Access Advisor ÈçºÎ½â¾ö³£¼ûÎÊÌâ¡££¨×¢£º³öÓÚÑÝʾĿµÄ£¬ÎÒÃǽ«Í¨¹ýÒ»¸öÓï¾äÑÝʾÕâ¸ö¹¦ÄÜ£»µ«ÊÇ£¬Oracle ½¨ÒéʹÓà SQL Access Advisor À´°ïÖúµ÷ÕûÕû¸ö¸ºÔØ£¬¶ø²»Ö»ÊÇÒ»¸ö SQL Óï¾ä¡££©
ÎÊÌâ
ÏÂÃæÊÇÒ»¸öµäÐÍÎÊÌâ¡£Ó¦ÓóÌÐò·¢³öÁËÒÔÏ SQL Óï¾ä¡£¸Ã²éѯËƺõÒªÏûºÄ´óÁ¿×ÊÔ´²¢ÇÒËٶȺÜÂý¡£
select store_id, guest_id, count(1) cnt
from res r, trans t
where r.res_id between 2 and 40
and t.res_id = r.res_id
group by store_id, guest_id
/
¸Ã SQL Éæ¼°Á½¸ö±í£¬¼´ RES ºÍ TRANS£»ºóÕßÊÇÇ°ÕßµÄ×Ó±í¡£ÄúÐèÒªÕÒµ½Ìá¸ß²éѯÐÔÄܵĽâ¾ö·½°¸ — SQL Access Advisor ÕýÊÇ×îºÏÊʵŤ¾ß¡£
Äú¿ÉÒÔͨ¹ýÃüÁîÐлò Oracle ÆóÒµ¹ÜÀíÆ÷Êý¾Ý¿â¿ØÖÆÓë¹ËÎʳÌÐò½øÐн»»¥£¬µ«Ê¹Óà GUI ¿ÉÒÔÌṩ¸üºÃµÄÖµ£¨GUI ¿ÉÈÃÄú½«½â¾ö·½°¸¿ÉÊÓ»¯£¬²¢½«Ðí¶àÈÎÎñ¼ò»¯Îª¼òµ¥µÄµã»÷²Ù×÷£©¡£
ҪʹÓÃÆóÒµ¹ÜÀíÆ÷ÖÐµÄ SQL Access Advisor ½â¾ö SQL ÖеÄÎÊÌ⣬Çë×ñÑÒÔϲ½Öè¡£
µ±È»£¬µÚÒ»¸öÈÎÎñÊÇÆô¶¯ÆóÒµ¹ÜÀíÆ÷¡£ÔÚ Database Ö÷Ò³ÉÏ£¬ÏòϹö¶¯µ½Ò³Ãæµ×²¿£¬Äú½«ÔÚÕâÀï¿´µ½¼¸¸ö³¬Á´½Ó£¬ÈçÏÂͼËùʾ£º
Ôڸò˵¥ÖУ¬µ¥»÷ Advisor Central£¬Õ⽫ÏÔʾһ¸öÓëÏÂͼÀàËƵÄÆÁÄ»¡£ÏÂÃæ½öÏÔʾÁ˸ÃÆÁÄ»µÄ¶¥²¿¡£
µ¥»÷ SQL Advisors£¬Õ⽫ÏÔʾһ¸öÓëÏÂͼÀàËƵÄÆÁÄ»¡£
ÔÚ¸ÃÆÁÄ»ÖУ¬Äú¿ÉÒԼƻ® SQL Access Advisor »á»°£¬²¢Ö¸¶¨ÆäÑ¡Ïî¡£¹ËÎʳÌÐò±ØÐëÊÕ¼¯Ò»Ð©ÒªÊ¹ÓÃµÄ SQL Óï¾ä¡£×î¼òµ¥µÄÑ¡Ïî¾ÍÊÇͨ¹ý Current and Recent SQL Activity ´Ó¹²Ïí³Ø
Ïà¹ØÎĵµ£º
http://www.umgr.com/blog/PostView.aspx?bpId=36294
1. Ö´ÐÐsqlÓï¾ä
int sqlite3_exec(sqlite3*£¬ const char *sql£¬ sqlite3_callbacksql Óï·¨
£¬ void *£¬ char **errmsg );
Õâ¾ÍÊÇÖ´ÐÐÒ»Ìõ sql Óï¾äµÄº¯Êý¡£
µÚ1¸ö²ÎÊý²»ÔÙ˵ÁË£¬ÊÇÇ°Ãæopenº¯ÊýµÃµ½µÄÖ¸Õ롣˵ÁËÊǹؼüÊý¾Ý½á¹¹¡£
µÚ2¸ö²ÎÊýconst char ......
2008-04-10 09:45 //*******FactoryManage.cs using System;
using System.Reflection;
using System.Configuration;
using CoalTraffic.IDAL; namespace CoalTraffic.DALFactory
{
/// <summary>
/// ³éÏ󹤳§Ä£Ê½´´½¨DAL¡£
......
SqlHelper ÀàʵÏÖÏêϸÐÅÏ¢
SqlHelper ÀàÓÃÓÚͨ¹ýÒ»×龲̬·½·¨À´·â×°Êý¾Ý·ÃÎʹ¦ÄÜ¡£¸ÃÀ಻Äܱ»¼Ì³Ð»òʵÀý»¯£¬Òò´Ë½«ÆäÉùÃ÷Ϊ°üº¬×¨Óù¹Ô캯ÊýµÄ²»¿É¼Ì³ÐÀà¡£
ÔÚ SqlHelper ÀàÖÐʵÏÖµÄÿÖÖ·½·¨¶¼ÌṩÁËÒ»×éÒ»ÖµÄÖØÔØ¡£ÕâÌṩÁËÒ»ÖֺܺõÄʹÓà SqlHelper ÀàÀ´Ö´ÐÐÃüÁîµÄģʽ£¬Í¬Ê±Îª¿ª·¢ÈËԱѡÔñ·ÃÎÊÊý¾ÝµÄ·½Ê½ÌṩÁ˱ØÒ ......
È·¶¨¸ø¶¨µÄ×Ö·û´®ÊÇ·ñÓëÖ¸¶¨µÄģʽƥÅ䡣ģʽ¿ÉÒÔ°üº¬³£¹æ×Ö·ûºÍͨÅä·û×Ö·û¡£Ä£Ê½Æ¥Åä¹ý³ÌÖУ¬³£¹æ×Ö·û±ØÐëÓë×Ö·û´®ÖÐÖ¸¶¨µÄ×Ö·ûÍêÈ«Æ¥Å䡣Ȼ¶ø£¬¿É ʹÓÃ×Ö·û´®µÄÈÎÒâƬ¶ÎÆ¥ÅäͨÅä·û¡£ÓëʹÓà = ºÍ != ×Ö·û´®±È½ÏÔËËã·ûÏà±È£¬Ê¹ÓÃͨÅä·û¿Éʹ LIKE ÔËËã·û¸ü¼ÓÁé»î¡£Èç¹ûÈκβÎÊý¶¼²»ÊôÓÚ×Ö·û´®Êý¾ÝÀàÐÍ£¬Microsoft SQL Server ......
ת×Ô£º°Ù¶È°Ù¿Æ
Ëùν¶Ë¿Ú£¬¾ÍÊÇÏ൱ÓÚ»úÆ÷ÓëÍâ½ç½Ó´¥µÄ´°¿Ú¡£¶Ë¿ÚÆäʵÊÇÈí¼þµÄ´°¿Ú£¬¾ÍÊÇ˵һ¸öÈí¼þÈç¹ûÒªºÍÍâ½çÁªÏµ£¬¾Í±ØÐë´ò¿ªÒ»¸ö¶Ë¿Ú£»1434¶Ë¿ÚÊÇ΢ÈíSQL Serverδ¹«¿ªµÄ¼àÌý¶Ë¿Ú¡£ÄãҪʹÓÃSQL£¬¾Í±ØÈ»´ò¿ª1433ºÍ1434¶Ë¿Ú¡£
ĬÈÏÇé¿öÏ£¬SQL ServerʹÓÃ1433¶Ë¿Ú¼àÌý£¬ºÜ¶àÈ˶¼ËµSQL ServerÅäÖõÄʱºòÒª°ÑÕâ¸ö¶Ë¿Ú¸Ä± ......