CrazyEngineers Forum - Computer Science & IT Engineering |
- Internet Filtering
- Indexing "QUERY PROCESSING TIME" AND factors responsible
- Does Windows Turn Off Wi-Fi Adapter In Sleep Mode?
| Posted: 13 Apr 2011 11:58 PM PDT Hi all, I have seen some sites which gives access to blocked sites . Some sites which provide these services are vtunnel.com. These are called as internet filtering.Can anyone tell how these sites actualy work. Also if i get orkut site through vtunnel. I was seeing some other ads alongwith some other scripts in the page.Is is safe to use those orkut page. Is it fake???Please let me know. |
| Indexing "QUERY PROCESSING TIME" AND factors responsible Posted: 13 Apr 2011 05:09 PM PDT :rolleyes::rolleyes::rolleyes::rolleyes: hi i have following question which i would love to learn in detail Emp ( empno,ename,hiredate,job,salary) 95% of job sal lies between 40000-45000 how can index on one field such as salary can increase or decrease query execution time ?? to give example of query select empno,ename from emp where salary/365>12; Please explain or give link or share idea not only in this case but in other also how query execution time is affected ( have a relation with query optimisation concepts ) here we do not have to predict what time(query execution is faester or may be slower ie we have to guess) it may take which depends on some factors like arthmetic expression used, predefined sql syntax like set opertaions etc used in query , it is possible to predict whether query will execute faster or slower and what is responsible for it seeing the index and query just want to know in depth of the concept understanding from above example |
| Does Windows Turn Off Wi-Fi Adapter In Sleep Mode? Posted: 13 Apr 2011 04:07 AM PDT I've had this question in mind since long. When I put my laptop in sleep mode does the wi-fi adapter get turned off? Or does it remain functional? I've no way to verify as the adapter has no LED to indicate the on/off status. Can someone throw more light on this? |
| You are subscribed to email updates from CrazyEngineers Forum - Computer Science & IT Engineering To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment